Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
this is my Formula but the value keep changing the value of sale when im selecting a range of date. please help me to fix and be in-depended of date rage
sum( aggr (sum (DISTINCT[AMOUNT]),[ID]))
Couple of Design Blog posts that might be useful in getting things sorted on your own if you are still working on them, otherwise other members may find them helpful on this one:
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
If you did figure things out, it would be appreciated if you would return to the thread, post what you did, and then mark that post as the solution by using the Accept as Solution button to close things out.
Regards,
Brett
Regards,
Brett
Try including set analysis in aggregation functions like:
sum( {<YourDatefield>} aggr (sum ( {<YourDatefield>} DISTINCT[AMOUNT]),[ID]))
Thanks For your repply but it makes my value to '0'
Perhaps, something is not being done properly. Could you share a sample app to check?
Couple of Design Blog posts that might be useful in getting things sorted on your own if you are still working on them, otherwise other members may find them helpful on this one:
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
If you did figure things out, it would be appreciated if you would return to the thread, post what you did, and then mark that post as the solution by using the Accept as Solution button to close things out.
Regards,
Brett
Regards,
Brett