selection on buttons

[prma7799]

Hi All,

Can anybody give me solution for below requirement.

I have one table pivot in that I have implement bullets and also take two images as below.

Now I want when i click green arrow/button it should display only green values and for red it should display red values.

Formula : if([M Gwth %] >0  ,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

2) How to display top 10 value/records in pivot/straight table?

Thanks

[Anonymous]

Hi

try dimension limits in straight table .

[qlikmsg4u]

Hi,

1. Is [M Gwth %] is calculated or direct field in data model? If it is direct field you can use text box select in field action to get desired result.

2. To display top 10 values you can use Dimension Limit tab in properties.

[prma7799]

Hi,

1.[M Gwth %] is not calculated in Data model it is only calculated in front end.

2. I want display top 10 values in Pivot table

Is there any another way to achieve it.

Thanks

[prma7799]

Hi Experts ,

MayilVahanan‌

jagan‌

swuehl‌

Can you please help me on this.

Thanks

[MayilVahanan]

Hi

I want display top 10 values in Pivot table :

You can try with Rank() function, for ex:

If(Rank(sum(Sales), 0, 4) <= 10, Sum(Sales))

Now I want when i click green arrow/button it should display only green values and for red it should display red values.

Green and Red arrow are in Text box ?

[PrashantSangle]

Hi,

1)

Create 2 chart one having only green arrow value and another for only red arrow value

create variable say vShow

Create 2 Button on for red and Green Arrow

For Green Arrow Button go to Property ->Action-> Add Action -> External->SetVariable->enter variable Name and set Value 1

then Go to chart Propertu having only Green Arrow Value->Property->Layout->conditional->Write  if(vShow=1,1,0)

Do the same thing for another chart also.

Regards

[qlikmsg4u]

Other way you can use is Rank function

[prma7799]

Hi Thanks for reply..

Yes the Green and Red arrow are in Text box and another one are bullets which used in pivot table.

Thanks

[prma7799]

Anybody give some light on this?