Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sunitha_chellaiah
Partner - Creator
Partner - Creator

If condition not working

Hi,

I am using value list in dimension. 

While using if condition in pivot table , the list is not showing all the values.

Dimension :

=ValueList('Cts','Gms','SP')

Expression :

 if(ValueList('Cts','Gms','SP')='Cts',sum(aggr(sum( DISTINCT NU_NETT_WTT),VC_VOUCHER_NO,VC_LABEL_NO)),
if(ValueList('Cts','Gms','SP')='Gms',sum(aggr(sum( DISTINCT NU_CARRAT_WTT),VC_VOUCHER_NO,VC_LABEL_NO)),
if(ValueList('Cts','Gms','SP')='SP',sum(aggr(sum( DISTINCT DIA_VALUE_SP),VC_VOUCHER_NO,VC_LABEL_NO))
)))

sunitha_chellaiah_0-1619013271984.png

It is showing only first value, remaining is not showing.

Kindly help to correct this.

Thanks.

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

On the chart presentation pane, uncheck "Suppress Zero Values" to see if those rows are being calculated as zero.

-Rob