Different measurement

Thu, 24 Jun 2010 03:42:02 GMT

Hi all,

I've a requirement where i need to create a variables to use on the screen by users to adjust unit of measure between 3 options to display in measures.

e.g: Variables: vUnitOfMeasureSelect - possible values: Tonnes,GSV,Qty

My initial idea will be using LET to create the variables. But i'm not too sure how i can use the variables created to relate it to the columns i have in my tables.

e.g: I've Sales_Qty,Sales_Tonnes,Sales_GSV in 1st table

and FCST_Qty,FCST_Tonnes,FCST_GSV in 2nd table

How can i use selection of QTY,TONNES,GSV on my screen?

Thanks in advance.

Different measurement

sparur — Thu, 24 Jun 2010 06:35:22 GMT

Hello.

I think, you should create 3 copies of your chart, each copy for each value of variable.

And show/hide chart by value of variable (see Show Condition option in the Layout tab in properties of chart)

for example "Show condition": vUnitOfMeasureSelect= 'Tonnes' so this chart will be shown only when your variable will be equal Tonnes. etc...

topic Different measurement in QlikView

Different measurement

Different measurement