Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression working even if colomn is empty

Hi,

I have this charts with an expression :

if (designation<>'COMMUNS',

Sum ( {$<sens={0} >} montant)- SUM ( {$<sens={1}>} montant)

,(Sum (TOTAL{$<sens={0}, designation={'COMMUNS'} >} montant)- SUM (TOTAL{$<sens={1}, designation={'COMMUNS'}>} montant))*'0,1')

As you can see in the excel file, I don't have any resultat in the yellow field.

when the colomn total is empty, the expression doesn't calculate 23 560 as I would like it to do...

It only works for the 1st colum... (A1)

Any idea ?

Cheers

Clement

0 Replies