Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Currently, I'm encountering an issue with the function sum() with the "indicator".
With the dynamic table, we have "Total function" and I don't this issue because with "Total function" the table is capable to sum each line and ignoring null values:
function: if(Amount_Eur = Solde, null(), sum(Solde))
But when I try to make this same sum with "indicator", I don't get the same sum because this function still summing null value:
Do we have something like "Total function" with the "indicator"?
Thanks in advance.
Regards
Try soMething like this:
Sum({<dimension-={"null()"}>}measure)
Hello Omar Bensalem,
Thank for your answer.
It's the first time I saw a function like that.
what's mean: {<dimension-={"null()"}>}
Until now, I always used some simple function with: if()
Thank in advance.
Regards
Did it do the trick for you?
This is a Set Analysis expression, it is powerful. In this example you calculate your formula but you don't take care about null values.
Documentation on the help:
Or helpful doc:
https://community.qlik.com/docs/DOC-4951
Rgds.
Hi Kenny
What's Omar gave you is called a Set Analysis
see this doc for further information.
https://community.qlik.com/blogs/qlikviewdesignblog/2015/02/16/set-analysis
I see your qlik sense version is in french ; you can also post your question in the french forum
regards
That is expression search