topic Re: Help in expression in pivot table? in QlikView

Help in expression in pivot table?

Mon, 10 Mar 2014 10:59:02 GMT

Hi,

I have below expression in pivot table

Count( DISTINCT{$<Product={'Soaps'},Delievery={'Postal'},Result={'Success'},Flag={1}>}ProductID)

I would need to change the expression whihc is like below

Product equal to Soaps but Delievery not equal to Postal

How can I change the avove expression? can anyone help me

Thanks.

rustyfishbones — Mon, 10 Mar 2014 11:02:48 GMT

add a minus in front of -={'Postal'}

Count( DISTINCT{$<Product={'Soaps'},Delievery-={'Postal'},Result={'Success'},Flag={1}>}ProductID)}

Mon, 10 Mar 2014 11:05:10 GMT

Thanks. Perfect