Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
You could use 2 buttons and a variable to show one expression at a time.
Please find .qvw attached
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
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))
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