Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get dimension value in expression

Is there any way to get dimension value inside expression using set anaysis?

I need to get average sum of previous values not using function above.

Amount of "steps" for average sum calculations is set by slider value.

Also, if I select some values if field "Num" it should calculates correctly.

There is only one problem, it calculates correctly only for the maximum value in field "Num".

For all previous values resulting value is incorrect.

Please advice how to correct formula to let it calculate correctly fot all other "Num" values?

It works now only for one max value...

There is .qvw file with all calculations and formulas.

Please see some screenshots of chart with correct/incorrect values.

for_community.png

for_community2.png

Thanks in advance!

0 Replies