If condition not working

sunitha_chellaiah — Wed, 21 Apr 2021 13:55:36 GMT

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))
)))

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

Kindly help to correct this.

Thanks.

Re: If condition not working

rwunderlich — Wed, 21 Apr 2021 14:26:42 GMT

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

-Rob

topic If condition not working in QlikView

If condition not working

Re: If condition not working