topic Re: IF function in QlikView

IF function

Anonymous — Wed, 14 Aug 2013 09:40:48 GMT

ID	Amount
AAA	10
BBB	0
CCC	3
DDD	0

I would simply want to sum amount with value (not zero) so i use SUM(IF(Amount > 0, Amount)) but it turns out wrong.Alternatively want to display only ID's with Amount.

Thanks

Kwame

Re: IF function

tresB — Wed, 14 Aug 2013 09:52:53 GMT

PFA

Re: IF function

CELAMBARASAN — Wed, 14 Aug 2013 09:54:05 GMT

Try with this

Sum({<Amount={"<>0"}>} Amount)

Which type of chart you are using?

Re: IF function

Anonymous — Wed, 14 Aug 2013 10:06:15 GMT

Preferably a pivot table

Re: IF function

er_mohit — Wed, 14 Aug 2013 10:40:52 GMT

simply try add ID in Dimension

and write expression Sum(Amount)

it gives you the data without zero but make sure that in presentation tab check on suppress zero values

and if there's other column having data and you want to supress this row where Amount zero then use that column like if it is your 1st column then try to put condition in 2nd column for that partiular field in this way

if(Column(1)=0,0,condition for other column then it automatically supres that row

hope it helps