4 Replies Latest reply: Mar 13, 2017 1:23 PM by Amir Jaber RSS

    Ignore dimension in set analysis | Qlik Sense

    Amir Jaber

      Hi,

       

      I am wondering what type of syntax I would use if I want return values outside of the dimension. E.g. for the following source data...

       

      DaySales
      110
      211
      312
      Total33

       

      ...if I wanted to show a table with the relative sales as a percentage each day, so as to return the following.

       

      DaySales (%age)
      130.3%  (10/sum of total sales, i.e. 33)
      233.33%
      336.4%
      Total33

       

      I am fairly familiar with using the set analysis to ignore selections (filters) but I haven't been able to figure out how to (or if it's possible to) do the same with regards Dimension.