Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table expression format diffrence

Hi everyone,

I have a pivot table sum that it does not show if i format my expresion in a specific way.

The sums show correctly at the 1st expression:

if( b.Year < SubField(vTODAY,'-',1),sum(b.QtyInvoiced),if(b.Month < SubField(vTODAY,'-',2),sum(b.QtyInvoiced),sum(b.ForecastQty)))

But do not show at the 2nd expression:

sum(if( b.Year < SubField(vTODAY,'-',1),b.QtyInvoiced,if(b.Month < SubField(vTODAY,'-',2),b.QtyInvoiced,b.ForecastQty)))

Can anyone enlighten me what is the diffrence between those two???as well as when to use one or another???


1 Reply

Have a look at this discussion