6 Replies Latest reply: Mar 2, 2017 7:15 AM by Xavier HEMELAAR 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


      https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/SetAnalysis/set-analysis-expressions.htm


      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


      sum({1<[Country]=P([Country])>}Sales).


      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