topic Re: Fast change Dimension or measure on button selection in Integration, Extension & APIs

Fast change Dimension or measure on button selection

qlikviewajeet — Tue, 11 Jul 2017 06:49:21 GMT

Hi ,

I want to change graph on button selection in Qlik Sense. Graph or chart expression will change, user click on Button Sales or Quantity . for this I have used extension.

it shows last measure (qty) by default. not changing on button click. Helpful solution was shared by Andy. click on this thread >Makes Sense to go round in circles

if I pass 1 inside variable, this shows sales and neither button click work nor show quantity

Regards

Ajeet

Re: Fast change Dimension or measure on button selection

vinieme12 — Tue, 11 Jul 2017 08:43:03 GMT

have you tried $ expansion with vTabview?

$(vTabview)

Re: Fast change Dimension or measure on button selection

paulyeo11 — Tue, 11 Jul 2017 09:06:59 GMT

Hi Ajeet

How about convert the table to bar chart. see the attachment,

Re: Fast change Dimension or measure on button selection

qlikviewajeet — Tue, 11 Jul 2017 09:09:39 GMT

yes, I am using below expression in Measure.

=if($(vTabView)=1,Sum(Sales), Sum(Quantity))

//=$(=Pick(Match($(vTabView),1,2),Sum(Sales),Sum(Quantity)))

//$(vSales),$(vQuantity)

and below is screenshot of setting up variable button..

Regards

Ajeet

Re: Fast change Dimension or measure on button selection

qlikviewajeet — Tue, 11 Jul 2017 09:46:18 GMT

no sir, this is not relevant to my discussion. Let me hear suggestion like Vineeth.

Regards

Ajeet