topic Re: Return only rows with zero values in table in QlikView

Return only rows with zero values in table

Anonymous — Fri, 29 Jan 2016 10:09:12 GMT

Hello

I would like to have below table but only with the rows for which the column Return Volume is zero.

I have country, year, month, Applicable on Brand, Warranty, Model Type and Marketing offer as dimensions and Return volume etc as expressions.

Kindly advise how I can display this table with only the rows where Return Volume is zero

Many Thanks

Hasnaa

MayilVahanan — Fri, 29 Jan 2016 12:12:57 GMT

Try like this

Exp1: =if(Exp1 = 0, Exp1)

if(Column(1) =0, Exp2)

if(Column(1) =0, Exp3)

if(Column(1) =0, Exp4)

Anonymous — Fri, 29 Jan 2016 12:20:38 GMT

Thanks. it works