Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a database with column names as listed below -
I've created all my charts using USD Column as main measure and Cts as alternate measure.
When viewing i need to change my measure in all columns to Cts or USD,
Is it possible in a single button I can change this in a single filter
Customer | Country | salesman | USD | Cts |
If I understand you correctly you want a button (or a set of buttons) to change the measure used in the line chart. That can be done using an extension like qsVariable and a variable. See attached example.
If I understand you correctly you want a button (or a set of buttons) to change the measure used in the line chart. That can be done using an extension like qsVariable and a variable. See attached example.
The app you shared is showing me invalid visualization
That's because it's using the qsVariable extension. You need to install that extension.
how to download it?
can you provide me the link for that
I've added extension and can visualize it in my app.
How to add that to my data set
Your data set can only contain data. Extensions are not part of the data. What are you trying to do?
Now I have 2 alternative measures to be shown in my visualization
1. USD
2. Cts
Expression for USD = Sum({<Ptype={"Sal"}>} SalesAmount)
Expression for Cts = Sum({<Ptype={"Sal"}>} Qty)
I want USD and Cts Buttons (qsvariable)
How to add this?
Look at the example I posted. The properties of the qsVariable object will show you that I defined a variable called vMeasure there and that I added two values for that variable in the settings. The variabel vMeasure is then used as measure in the bar char using the expression $(vMeasure).