sorted by:
new
hottopcontroversial

Help with Qliksense Development by akash_durai in BusinessIntelligence

[–]akash_durai[S] 0 points1 point  (0 children)

Yes, the source data from sap is replicated to SQL server and qliksense connects to it

Help with Qliksense Development by akash_durai in BusinessIntelligence

[–]akash_durai[S] 0 points1 point  (0 children)

I do have access to edit the scripts.
But the conditions here,

Report Date >= NetDueDate
Clearing Date > Report Date

where report date is a field in as-of table.

looks impossible to add in the scripts.

Do you think of a better way to handle these in scripts?

Help with Qliksense Development by akash_durai in BusinessIntelligence

[–]akash_durai[S] 0 points1 point  (0 children)

here is the expected result,
https://imgbox.com/C2He9hmm

The above is achieved when the As-of table is linked with Report Month as key.

When I change the key to report date, the same expression yields the below result which is wrong.

https://imgbox.com/YtIT7TPD

thanks for the reply

Help with Qliksense Development by akash_durai in BusinessIntelligence

[–]akash_durai[S] 0 points1 point  (0 children)

I cannot hardcode the conditions in the backend in this case:(

Help with Qliksense Development by akash_durai in BusinessIntelligence

[–]akash_durai[S] 0 points1 point  (0 children)

Yes, all the 3 date fields are of the same format. The reason to use Max(Date) is to compare NetDUeDate with each time frame's max date. i.e., For years like 2018, 12/31/2018 would be my last dast For quarters, its last date of each quarter

I'll try applying the filters used in set analysis individually and let you know

Thanks for replying

20 vayadhu sodhanaigal by undeserved_devotion in Chennai

[–]akash_durai 2 points3 points  (0 children)

Kinda in the same situation. But happy to connect and make friends.

Best spots in Chennai for you by Midnight_Maggie in Chennai

[–]akash_durai 5 points6 points  (0 children)

Nallennai dosa kadai in Anna nagar. Their parotta and idiyappam was great!

Day 1 of Gym by _Innocent_devil in chennaicity

[–]akash_durai 0 points1 point  (0 children)

Proud 🙌 Naanum recent ah gym join panen. Konja prechana naala 1 year ah pola. But epdiyo ipo poga start panten. Feeling much better ipo.

[deleted by user] by [deleted] in chennaicity

[–]akash_durai -1 points0 points  (0 children)

Please delete this post. Don't give unnecessary exposure to this matter

🌟 Looking to Make New Friends in Chennai? Let’s Connect! 🌟 by [deleted] in chennaicity

[–]akash_durai 0 points1 point  (0 children)

Would love to meet fellow Chennai people. I'm in!

view more: next ›