1 Reply Latest reply: Nov 18, 2017 3:22 AM by Toni Kautto RSS

    Having multiple measures in single selection

    Sreekanth Kotturi

      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%