2 Replies Latest reply: Jul 29, 2018 8:11 AM by Priyal Paithankar RSS

    How to do conditional drill down in qlik?

    Priyal Paithankar

      Hi All,

       

      I have Following table.

      HeadingAmount
      Gross Sale 100
      Discount10
      Net Sale90
      Cogs30
      Gorss Profit60

       

      I want to create a drill down dimension.

      Level 1 As Heading

       

      Level 2 as

      If (Heading='Gross sale',Dimension A,

      If (Heading='Discount',Dimension B))

      But Its Not WORKING ....

      PLEASE HELP.

      Regards....