topic Re: Action buttons on two variables in QlikView

Action buttons on two variables

canmarroig — Fri, 25 Oct 2013 04:54:00 GMT

Hi, i'm facing this problem: i've a bar graph where i'm showing

sum(sales)

count(customers)

sum(goodsdelivered)

etc.

My customer is asking me to have an action button for switching from sum to avg. No problem i've created a variable vAggr to do it

if(vAggr='sum', sum(sales), if(vAggr='avg', avg(sales))

Then he asked me to cycle on time dimension not with a classic QV symbol but he wants further buttons to set Year, Month,ecc

I tried with a further variable vTime but when i try to use it, it stops calculating avg. I use this expression:

if(vAggr='sum', sum(sales), if(vAggr='avg', sum(sales)/count (distinct $(vTime)))

Where is the problem, i can't see it. Tks

Re: Action buttons on two variables

Fri, 25 Oct 2013 05:04:35 GMT

Hi,

What you have in the variable $(vTime)

Re: Action buttons on two variables

v_iyyappan — Fri, 25 Oct 2013 05:19:33 GMT

Hi,

I assume vTime like Year, Month based on button selection it will change the Year or Month.

using the Conditional option in expression use like this

vTime = 'Year'

if(vAggr='sum', sum(sales), if(vAggr='avg', sum(sales) / Count (distinct Year)))

vTime = 'Month'

if(vAggr='sum', sum(sales), if(vAggr='avg', sum(sales) / Count (distinct Month)))

Hope its help.

Otherwise provide the sample app for that

Regards,

Re: Re: Action buttons on two variables

Fri, 25 Oct 2013 05:20:37 GMT

Hii Amuthabharati,

I am attaching a file for the same button action, go for it ,

Hope it helps.

Re: Action buttons on two variables

jagan — Fri, 25 Oct 2013 06:10:57 GMT

Hi,

Please find attached file, hope it helps you.

Regards,

Jagan.

Re: Action buttons on two variables

canmarroig — Fri, 25 Oct 2013 06:46:33 GMT

I've Year, Month, Week, Fiscal Quarter, Date

Re: Action buttons on two variables

canmarroig — Fri, 25 Oct 2013 06:48:53 GMT

Yes, correct for sum or avg but also to cycle on x axis dimension i need furrther buttons

Re: Re: Action buttons on two variables

jagan — Fri, 25 Oct 2013 06:57:49 GMT

Hi,

PFA file for solution.

Regards,

Jagan.