topic Re: Showing top 10 by button in QlikView

Showing top 10 by button

priyarane — Mon, 13 Apr 2015 18:11:52 GMT

Hi Community Team,

I have requirement like below

I wanted to show top 10 countries by button

I created a Pivot table in that dimension is Country and expression1 - sum(sales), expression2 - sum(sales1) - expression 2 used for only sorting and its hidden in presentation tab.

so, once I click on button then top 10 countries should show.

Please help me.

Re: Showing top 10 by button

sunny_talwar — Mon, 13 Apr 2015 18:17:20 GMT

You can create an expressions which is conditional based on the value of a variable.

If(vVar = 0, Sum(Sales), Sum({<Country = {"Rank(Sum(Sales)) <=10"}>} Sales))

Your button will have an action which set vVar to be =If(vVar = 0, 1, 0)

I hope this helps.

Best,

Sunny

Re: Showing top 10 by button

ecolomer — Mon, 13 Apr 2015 18:24:36 GMT

here you have an example

Re: Showing top 10 by button

ecolomer — Mon, 13 Apr 2015 18:25:31 GMT

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 18:48:08 GMT

Hi Sunindia,

thank for reply. could you please brief about it.

My requirement is.

Dim: Country Expression: Sum(Sales)

India 20000

Brazil 19000

US 18000

Canada 16000

Kenya 15000

France 60000

UK 5000

Germany 3000

so,

Now, in my 1st button action should be - top 3-- so once I click on it then India, Brazil, US should display in Chart

like that I have top4 button etc....

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 18:49:27 GMT

Thank for reply Enrique.

My requirement should be display by button like below

Dim: Country Expression: Sum(Sales)

India 20000

Brazil 19000

US 18000

Canada 16000

Kenya 15000

France 60000

UK 5000

Germany 3000

so,

Now, in my 1st button action should be - top 3-- so once I click on it then India, Brazil, US should display in Chart

like that I have top4 button etc....

Re: Showing top 10 by button

Mon, 13 Apr 2015 18:55:01 GMT

So you want a button that on the first touc will give you top3, on the second - top 4 and so on?

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 18:59:54 GMT

Yes,

but separate button like 1st button - top3 countries and second button top4 countries.

My requirement should be display by button like below

Dim: Country Expression: Sum(Sales)

India 20000

Brazil 19000

US 18000

Canada 16000

Kenya 15000

France 60000

UK 5000

Germany 3000

so,

Now, in my 1st button action should be - top 3-- so once I click on it then India, Brazil, US should display in Chart

like that I have top4 button etc....

Re: Showing top 10 by button

sunny_talwar — Mon, 13 Apr 2015 19:10:49 GMT

Please find attached:

Minor edit to the expression: If(vVar = 0, Sum(Sales), Sum({<Country = {"=Rank(Sum(Sales)) <=10"}>} Sales))

Best,

Sunny

Re: Showing top 10 by button

maxgro — Mon, 13 Apr 2015 19:44:52 GMT

button action select in field

search action ='$(v)'

variable v ='(' & concat(if(aggr(Rank(Sum(sales)),country)<=3,country), '|') & ')'

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 19:44:53 GMT

Hi,

Please check my requirement as attached

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 19:55:13 GMT

Hi,

Please check my requirement as attached

Re: Showing top 10 by button

sunny_talwar — Mon, 13 Apr 2015 19:59:25 GMT

Is this what you are looking for?

PFA

Best,

Sunny

Re: Showing top 10 by button

maxgro — Mon, 13 Apr 2015 20:02:55 GMT

for top 3, vVar

='(' & concat(if(aggr(Rank(Sum(Sorting)),Country)<=3,Country), '|') & ')'

button:selectin field

='$(vVar)'

as in my previous post

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 20:25:11 GMT

Hi Massimo,

Its working but my requirement is 2 buttons

1st button - 3

2nd button - 4

like that

Re: Showing top 10 by button

Anonymous — Mon, 13 Apr 2015 20:26:28 GMT

See the attached , just a different approach. Instead of the buttons I loaded your top value selections using inline. see if this works.

Re: Showing top 10 by button

maxgro — Mon, 13 Apr 2015 20:27:33 GMT

what about adding another variable for top 4? just replace in new variable <=3 with <=4

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 20:28:43 GMT

even I create 2 variables added action to 2 buttons

but problem is here,

I can select top4 and top 3 button

but I can't select top3 and top4

like attached

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 20:41:36 GMT

Its good approach,

But i need to put action on sorting only expression, it will be hidden.

Re: Showing top 10 by button

priyarane — Mon, 13 Apr 2015 20:47:34 GMT

I am not getting you