topic Re: AGGR function - it changes value based on range in QlikView

AGGR function - it changes value based on range

nima94 — Mon, 10 Aug 2020 05:36:46 GMT

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]))

Re: AGGR function - it changes value based on range

tresB — Mon, 10 Aug 2020 05:42:35 GMT

Try including set analysis in aggregation functions like:

sum( {<YourDatefield>} aggr (sum ( {<YourDatefield>} DISTINCT[AMOUNT]),[ID]))

Re: AGGR function - it changes value based on range

nima94 — Mon, 10 Aug 2020 06:34:25 GMT

Thanks For your repply but it makes my value to '0'

Re: AGGR function - it changes value based on range

tresB — Mon, 10 Aug 2020 07:02:22 GMT

Perhaps, something is not being done properly. Could you share a sample app to check?

Re: AGGR function - it changes value based on range

Brett_Bleess — Tue, 25 Aug 2020 15:10:50 GMT

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

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

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