Qlik Sense: sum()

[#1]

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

[OmarBenSalem]

Try soMething like this:

Sum({<dimension-={"null()"}>}measure)

[#3]

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

[OmarBenSalem]

Did it do the trick for you?

[jugrimault]

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:

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

Or helpful doc:

https://community.qlik.com/docs/DOC-4951

Rgds.

[brunobertels]

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

[vinieme12]

That is expression search

The Expression Search