variable issue

[#1]

Hey!!

i am pretty much new to Qlikview.

i wanted to know how can we find the "top sales(or something else) and bottom sales" using a variable.

need some guidance please.

[vikasmahajan]

PFA sample Application.

vikas

[Michiel_QV_Fan]

It is possible to work with variables. The question is, why?

You can use dimension limits to generate a top and bottom sales.

You can set a variable in the dimension limits to set a higher and lower value.

Please give more information on what you want to achieve, a screen shot might help too.

[#4]

Hello Michiel,

thanks for replying

i know the method you just described but the thing is i want another way using variables.

is it possible?

[ashwanin]

Hi Gatik,

Please describe on which you want to took the help. Because top 5 and below 5 and variables you know.

if you let know, what exactly you required then it helps to define that thing.

[MK_QSL]

Please find enclosed file.

You dont need Variable for this...

[#7]

Hey Ashwani

i have been assigned a task to find top 5 or bottom 5 using variables

we can find them using the dimension thing but i need to do it while using some variable.

i dont know how to do it with variables

[oleg_orlov · Accepted solution]

Hi!

If you want to get list of top/bottom values (for example Customers) you can try this:

'= Concat(if (Aggr(Rank(Sum(Sales)), Customer) <= 3, Customer), ',')'     // top 3 customers

'= Concat(if (Aggr(Rank(-Sum(Sales)), Customer) <= 3, Customer), ',')'    // bottom 3 customers

Oleg