Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sreekanth_mstr
New Contributor

Having multiple measures in single selection

Hi,

Can somebody help me out to resolve the below issue in Qliksense,

1. I have a table chart with Dimensions as A, B, C and Measures as M1(displays values Ex:$1,234.00), M2(dispalys 10%).

2. I have a selection box for measures (M1 & M2). If i select M1 in the selection it displays the M1 values  with decimals($1,234.00) in the measure and if M2 is selected then M2 values are displayed as $10% which shouldn.t be.

Your inputs are highly appreciated.

Current Results:

When M1 is selected in the selections

ABMeasure(M1)
Product1Item1$100.00
Product2Items$200.00

When M2 is selected in the selections

ABMeasure(M2)
Product1Item1$10%
Product2Items$20%


Expected results
: (Only one Table not Two Tables for 2 measures(M1, M2)

When M1 is selected in the selections

ABMeasure(M1)
Product1Item1$100.00
Product2Items$200.00

When M2 is selected in the selections

ABMeasure(M2)
Product1Item110%
Product2Items20%
1 Reply
Employee
Employee

Re: Having multiple measures in single selection

You have to set the measure's number format to Measure formatting, and control the different formats by applying Num() in your measure's expression.

Community Browser