Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
sum({1<[Country]=p(), City = p() >}TOTAL Sales)
May be you need this?
Sum({1<[Country] = $::[Country]>}Sales)
Or maybe you need to additionally use the TOTAL qualifier (maybe with a field list)?
Sum({1<[Country] = $::[Country]>} TOTAL Sales)
see also
Hi Sunny, what does this do ? = $::[Country] ; It's first time seeing such an expression !
Hi,
Thanks for your quick response. So in fact I only needed to add TOTAL but at the right place:
sum({1<[Country]=P([Country])>}TOTAL Sales). This one works. If I put $:: instead of P the expression is not working as Qlik Sense doesn't reconize this syntax.
Last Question: if I want several fields to interact, like Country and City, what would be the syntax?
Thanks for your help
sum({1<[Country]=p(), City = p() >}TOTAL Sales)
Great !!
Hi Stefan,
Need a small help