Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hhajjali
New 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
MVP
MVP

Re: Calculate Standard Deviation Price for last not selected dimensions

Is it something like this you had in mind?

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

3 Replies
MVP
MVP

Re: Calculate Standard Deviation Price for last not selected dimensions

Is it something like this you had in mind?

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

hhajjali
New Contributor III

Re: Calculate Standard Deviation Price for last not selected dimensions

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

MVP
MVP

Re: Calculate Standard Deviation Price for last not selected dimensions

you're welcome