Having multiple measures in single selection

[sreekanth_mstr]

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

A	B	Measure(M1)
Product1	Item1	$100.00
Product2	Items	$200.00

When M2 is selected in the selections

A	B	Measure(M2)
Product1	Item1	$10%
Product2	Items	$20%

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

When M1 is selected in the selections

A	B	Measure(M1)
Product1	Item1	$100.00
Product2	Items	$200.00

When M2 is selected in the selections

A	B	Measure(M2)
Product1	Item1	10%
Product2	Items	20%

[ToniKautto]

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.