topic Re: Sales for top 2 values in QlikView

Sales for top 2 values

Fri, 20 Dec 2013 11:18:11 GMT

Hi,

I am trying to get the Sales for the top 2 values of a variable that i called Elapse for the last 2 years ( If i select Elapse=(-6) and Year=2012) i want to see in my table :

Year Elapse Sales

2012 -6 sum of sales

2012 -9 sum of sales

2011 -28 sum of sales

2011 -36 sum of sales

Please find attached my qvw.

thanks for your Help

Re: Sales for top 2 values

sujeetsingh — Fri, 20 Dec 2013 11:26:35 GMT

Se the sample is it what you want .

Plz explain

Re: Sales for top 2 values

Fri, 20 Dec 2013 11:39:47 GMT

Hi,

i am not looking for the sum of Elapse, i want to see the Sum of sales for top 2 Elapse Values and compare it with the last year. How can i add this condition in my set analysis expression in table (Top 2 Sales by Year / Elapse).

Please find below an example :

If i select Elapse=(-6) and Year=2012) i want to see in my table :

Year Elapse Sales

2012 -6 sum of sales

2012 -9 sum of sales

2011 -28 sum of sales

2011 -36 sum of sales

Thanks a lot for your help