Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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!

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

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

View solution in original post

4 Replies
Highlighted
Specialist II
Specialist II

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

Please find .qvw attached

Highlighted
Specialist II
Specialist II

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

View solution in original post

Highlighted
Master II
Master II

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))

Highlighted

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