topic Re: variable issue in QlikView

variable issue

Wed, 12 Feb 2014 10:37:47 GMT

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 — Wed, 12 Feb 2014 10:42:12 GMT

PFA sample Application.

vikas

Michiel_QV_Fan — Wed, 12 Feb 2014 10:43:39 GMT

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.

Wed, 12 Feb 2014 10:54:07 GMT

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 — Wed, 12 Feb 2014 11:01:32 GMT

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 — Wed, 12 Feb 2014 11:03:14 GMT

Please find enclosed file.

You dont need Variable for this...

Wed, 12 Feb 2014 11:30:46 GMT

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 — Wed, 12 Feb 2014 11:49:07 GMT

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