3 Replies Latest reply: Mar 29, 2018 2:10 PM by Sunny Talwar RSS

    Variables and Dollar Sign Expansion in a Table

    Mark Perreault

      I have a question regarding variable and dollar sign expansion within a table in Qlik.  I have created a variable vSales = sum(Sales) .  I then have a table with the dimension being region and the measure being $(vSales).  I'd ideally want to my table to look like this

       

      RegionSales

      North

      25
      South25
      East 25
      West25

       

      however my result is this

       

      RegionSales
      North100
      South100
      East100
      West100

       

      The value for each region is the value for the whole dataset instead of being broken down by dimension.

       

      I understand I can just use sum(Sales) as my measure in the table however I am wondering if it possible to use variables and dollar sign expansion.


      Can anyone advise.