Selection of Different measures in single filter

[vikas_nandanwar]

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

[Gysbert_Wassenaar · Accepted solution]

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.

[vikas_nandanwar]

The app you shared is showing me invalid visualization

[Gysbert_Wassenaar]

That's because it's using the qsVariable extension. You need to install that extension.

[vikas_nandanwar]

how to download it?

can you provide me the link for that

[vikas_nandanwar]

I've added extension and can visualize it in my app.

How to add that to my data set

[Gysbert_Wassenaar]

Your data set can only contain data. Extensions are not part of the data. What are you trying to do?

[vikas_nandanwar]

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?

[Gysbert_Wassenaar]

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