topic Re: Create buttons with Actions in QlikView

Create buttons with Actions

bharani8 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts - For the attached chart.. i need to have 3 buttons.. say "0%-10%" ; "11%-20%",">20%"... When i click the "0%-10%" button... %'s belonging to those shuld reflect in my chart (chk attached qvw).. like wise for other buttons as well..

Re: Create buttons with Actions

prieper — Mon, 18 Sep 2017 09:58:30 GMT

Base formula may look like

IF(sum(Amt)/sum(TOTAL Amt) > 0.3 AND sum(Amt)/sum(TOTAL Amt) < 0.4, sum(Amt))

0.3 and 0.4 might be replaced by corresponding variables.

These variables might be set in a trigger.

Re: Create buttons with Actions

bharani8 — Mon, 18 Sep 2017 10:06:39 GMT

Can you show that in the qvw file ?

Re: Create buttons with Actions

Kushal_Chawda — Mon, 18 Sep 2017 10:27:14 GMT

see the attached

Re: Create buttons with Actions

bharani8 — Mon, 18 Sep 2017 10:31:25 GMT

Hi Kushal - is it possible to do without changing the expression? I mean.. with my old expression itself...

Re: Create buttons with Actions

antoniotiman — Mon, 18 Sep 2017 10:31:49 GMT

Hi Bharani,

see Attachment.

Regards,

Antonio

Re: Create buttons with Actions

Kushal_Chawda — Mon, 18 Sep 2017 10:33:46 GMT

No, as your requirement is by creating the buttons and click on that you need to change the expression

Re: Create buttons with Actions

Or — Mon, 18 Sep 2017 10:42:36 GMT

I'd recommend against the approach of only showing partial values (and I'd also recommend against using a line to show the percentages - there's no association between them and the line is misleading). I've used a similar approach to highlight the relevant values within the chart - suggestion is attached.

Re: Create buttons with Actions

bharani8 — Mon, 18 Sep 2017 10:42:53 GMT

Wow this looks So Simple!! Thanks!! But may i know why u changed the expression for % ? Why is that required? Can u plz explain to understand ?

Re: Create buttons with Actions

bharani8 — Mon, 18 Sep 2017 10:46:07 GMT

Hi Shoham - Good idea.. But my requirement is to show only those pertaining to those %'s... Not to Highlight..

Re: Create buttons with Actions

antoniotiman — Mon, 18 Sep 2017 10:46:15 GMT

Try with old expression and see the result.

Re: Create buttons with Actions

bharani8 — Mon, 18 Sep 2017 10:49:25 GMT

oh ok Got it!! It changes the % ..

Re: Create buttons with Actions

Kushal_Chawda — Mon, 18 Sep 2017 11:00:45 GMT

Using this methods you are selecting the dimensions value which will affect the other charts as well, if this is the requirement then you can go by this approach, but if you you don't want to affect the other charts by clicking on buttons then you need to change the expression as this approach won't work

Re: Create buttons with Actions

bharani8 — Mon, 18 Sep 2017 11:11:31 GMT

Can we use the Alternate state to avoid this ?

Re: Create buttons with Actions

Kushal_Chawda — Mon, 18 Sep 2017 11:16:03 GMT

Then anyway you need to change the expressions , right? why to make things complicated using alternate states, if you have many charts then you need to change expression in each and every chart for alternate states. Using my approach you need to change the expression of that particular chart only.

Re: Create buttons with Actions

Or — Mon, 18 Sep 2017 13:28:04 GMT

You can use the same mechanism with a calculated dimension - I just don't think it's the right way to go about it. You'll have to check the "Suppress when value is null" box.

=if(aggr(sum(Amt)/sum(Total Amt),Aging_Bucket1)>0.1,Aging_Bucket1)

Replacing the condition with variable-based conditions as in my previous example.

Re: Create buttons with Actions

bharani8 — Tue, 19 Sep 2017 06:17:08 GMT

Hi Kushal - In the above approach... In my case Dimension is Cyclic Drilldown... So is it possible to those kind of dimension as well ?

Re: Create buttons with Actions

Or — Tue, 19 Sep 2017 07:20:49 GMT

You'll have to replace every mention of AgingBucket1 with GetCurrentField(YourGroup). It should work, I think, regardless of which of these approaches you used.

Re: Create buttons with Actions

Kushal_Chawda — Tue, 19 Sep 2017 11:14:53 GMT

No problem, you can use same expression. If aggr is needed for your expression then, you can do something like below

=sum( aggr(YourExpression, $(vCyclicGroup)) )

where , vCyclicGroup = GetCurrentField([YourClyclicGroupName])

Re: Create buttons with Actions

bharani8 — Tue, 19 Sep 2017 13:56:40 GMT

Cool... Just curious to know if my case is going to be like this...

Assume, i have Cyclic Drilldown (2 Fields) as my Dimension... but i need this behavior for only one field (1st field) not for the 2nd Field in Cyclic Drilldown.. How do we deal with that?