topic TOP Values Based On Variables in QlikView

TOP Values Based On Variables

Mon, 07 Dec 2015 06:54:05 GMT

How to show top values based on variables in qliksense

Kindly help me

i top salaries of employes eg 5,10,15 top salaries

umartareen — Mon, 07 Dec 2015 06:56:53 GMT

Hi,

Have a look at this pic.

You can fix the limitation to 5 in the Dimension tab as seen in the pic above.

Also change your expression to just 'Sum(Salary)'

Regards,

Umar

umartareen — Mon, 07 Dec 2015 07:00:49 GMT

Or You may also use the variable instead of defining a specific number in the limitation box.

Regards,

Umar

Mon, 07 Dec 2015 07:03:32 GMT

thanku umar

but how to use variable in sense,

my requirement is based on user input values should change like top 10,20,30

umartareen — Mon, 07 Dec 2015 07:13:54 GMT

Okay You can make use of a slider just like how we do in Qlikview.

All you will need to do is enter the Variable name in the in the slider.

You can download the slider from the following links.

umartareen — Mon, 07 Dec 2015 07:34:24 GMT

Hi,

Hope this helps.