Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sreekanth_mstr
Contributor
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
ToniKautto
Employee
Employee

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.