topic selection on buttons in QlikView

selection on buttons

prma7799 — Tue, 14 Jul 2015 05:39:57 GMT

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

Re: selection on buttons

Anonymous — Tue, 14 Jul 2015 06:07:14 GMT

try dimension limits in straight table .

Re: selection on buttons

qlikmsg4u — Tue, 14 Jul 2015 06:09:53 GMT

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.

Re: selection on buttons

prma7799 — Tue, 14 Jul 2015 06:15:43 GMT

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

Re: selection on buttons

prma7799 — Tue, 14 Jul 2015 06:17:49 GMT

Hi Experts ,

MayilVahanan‌

jagan‌

swuehl‌

Can you please help me on this.

Thanks

Re: selection on buttons

MayilVahanan — Tue, 14 Jul 2015 06:22:43 GMT

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 ?

Re: selection on buttons

PrashantSangle — Tue, 14 Jul 2015 06:25:40 GMT

Hi,

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

Re: selection on buttons

qlikmsg4u — Tue, 14 Jul 2015 06:28:22 GMT

Other way you can use is Rank function

Re: selection on buttons

prma7799 — Tue, 14 Jul 2015 06:43:57 GMT

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

Re: selection on buttons

prma7799 — Tue, 14 Jul 2015 08:18:30 GMT

Anybody give some light on this?

Re: selection on buttons

qlikmsg4u — Tue, 14 Jul 2015 08:51:49 GMT

Please find the attached app

Re: selection on buttons

prma7799 — Tue, 14 Jul 2015 09:23:58 GMT

Hi @QLIKmsg4u

It is very helpful but when i implement in my application it will give me only hide n show effect.

Thanks

Re: selection on buttons

qlikmsg4u — Tue, 14 Jul 2015 09:27:35 GMT

What do you mean by hide n show effect?

Did you change the Dimension to Calculated Dimension according to your data?

Please attach your app to understand better

Re: selection on buttons

MayilVahanan — Tue, 14 Jul 2015 09:29:22 GMT

Please attach the sample file

Re: selection on buttons

prma7799 — Tue, 14 Jul 2015 09:38:23 GMT

Hi,

Am using six different dimension in one cyclic group. and it is not possible to attached sample file.

Thanks

Re: selection on buttons

prma7799 — Tue, 14 Jul 2015 11:01:02 GMT

Hi ,

@QLIKmsg4u

PFA

Re: selection on buttons

qlikmsg4u — Tue, 14 Jul 2015 11:24:16 GMT

Check the attachment, Is this OK?

Tried something, may be there is another way to do this , check sheet 2 and i worked on trnd and [M Gwth%] field

Re: selection on buttons

settu_periasamy — Tue, 14 Jul 2015 13:33:19 GMT

Hi,

you can get the result in single table. but it is bit hectic.

need to create 3 variables, and you have to put in your table expression.

find the attached for single table with result for your reference.