Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hhajjali
Contributor III
Contributor III

Calculate Standard Deviation Price for last not selected dimensions

Hello,

In my application I have calculated the price deviation as follow and it is working fine, it calculate the deviation taking into account the ITERATION I have selected.

Stdev(aggr(Sum([PRICE])/Sum({<[CATEGORY]={"1"}>}[NB ITEMS]),ITERATION))

The table bellow resume my DATA:

IterationNB ITEMSCATEGORYPRICE
IT1521000
IT1413500
IT231350
IT3911000
IT41114000
IT5413000

Here is my problem, I display always only 3 iteration in my report.  I need to calculate 2 KPI:

- stdev for the 3 selected iterations (which is done) ex: IT5,IT4,IT3

- stedv for the before last 3 selected iteration: ex: IT4,IT3,IT2

My goal is to display both stedv to tell if the stdev was better before or no.

Thanks for your help.

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Is it something like this you had in mind?

2018-01-21 13_42_15-Qlik Sense Desktop.png

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

Is it something like this you had in mind?

2018-01-21 13_42_15-Qlik Sense Desktop.png

hhajjali
Contributor III
Contributor III
Author

Thanks a lot for your help, combining range stdev and formulas in set analysis is the solution.

petter
Partner - Champion III
Partner - Champion III

you're welcome