topic Re: How to cycle between $ figures and units in bar chart? in QlikView

How to cycle between $ figures and units in bar chart?

Wed, 27 May 2015 10:05:26 GMT

I have a bar chart showing Sales Dollars and Purchases Dollars (expressions) by Month (Dimension). I would like to have a way for the user to choose to see Sales Units and Purchase Units instead of the dollar figures. How can I achieve that? I looked into grouping expressions but I would not like to have 2 cyclic buttons (one for sales and one for purchases). I would like to have one single button to change all expressions in the chart.

Thanks for the help!

Re: How to cycle between $ figures and units in bar chart?

danieloberbilli — Wed, 27 May 2015 10:13:12 GMT

You could use 2 buttons and a variable to show one expression at a time.

Please find .qvw attached

Re: How to cycle between $ figures and units in bar chart?

danieloberbilli — Wed, 27 May 2015 10:16:06 GMT

sorry - i didnt read it properly.

If you would like one button only you could use 1/0 in the variable and the action on one button with

=not(vShowExpression)

PFA

Re: How to cycle between $ figures and units in bar chart?

buzzy996 — Wed, 27 May 2015 10:16:46 GMT

may be,by writing expression tis way ..u can achieve this.

on ur expression: if(u select from list box/button dollars then ur expression should calculate sum(sales) else count(sales unites))

Re: How to cycle between $ figures and units in bar chart?

MarcoWedel — Wed, 27 May 2015 10:52:40 GMT

Hi,

instead of creating different expressions for sales and purchases you could create one expression for both and an additional calculated dimension like

valuelist('sales','purchases')

to distinct between both.

Your expression could look like

Pick(Match(valuelist('sales','purchases'),'sales','purchases'),

Expression1,

Expression2

)

If you do this seperately for dollars and unit count, you could switch between both with only one expression group.

hope this helps

regards

Marco