topic Re: table requirement in QlikView

table requirement

Fri, 23 Jan 2015 10:47:30 GMT

Hi,

How to remove row in straight and pivot table, if the Amount column has Zero values.

Thanks,

MLNR

alexandros17 — Fri, 23 Jan 2015 10:50:28 GMT

If Amount is the only expression then in Presentation check the box "Suppress Zero Values" otherways tell me more about dimensions and expressions

its_anandrjs — Fri, 23 Jan 2015 10:53:08 GMT

Hi,

In the Expression use conditional option and write

Ex:-

Suppose your expression is Sum(Amt)

if(Sum(Amt) =0,0,1)

Regards

Anand

its_anandrjs — Fri, 23 Jan 2015 10:56:59 GMT

And if it is dimension then write

Ex:-

Click on Enable conditional

if(IsNull(Amt ) = 0,0,1)

Regards

Anand

Anonymous — Fri, 23 Jan 2015 12:31:01 GMT

Hi,

for pivot table you can restrict in expression-Conditional: (=sum(Sales)>0).

In straight table Presentation- condition: if(Sum(Actual)>0,1,0)

Regard

Arun