7 Replies Latest reply: Mar 6, 2018 5:24 AM by prashanthi reddy RSS

    Set analysis disregarding dimension

    Xavier HEMELAAR

      Hi Qlikers,


      I found that with set Analysis I can use expresison below to sum my sales disregarding selections but not dimension. Is it possible to also disregard dimension? What is the syntax?


      sum ({1} Sales) :Returns total sales for the app, disregarding selections but not the dimension


      In fact I found a way doing: sum(ALL(Sales)). But I would like some of my selections to interact on my chart so I did this with set analysis


      But then in my chart that has [Import Date] on x-axis it will not sum ALL for each value of my dimension [Import Date] .

      So how to sum ALL and specify for some dimension that I want to be able to interact with my chart?

      Thanks for your help