topic Hiding rows in a straight table in QlikView

Hiding rows in a straight table

ajithsachin — Wed, 24 Jul 2013 05:29:36 GMT

Hi All,

I have a straight table and i need to suppress rows as per my expression.

Example i have a sum(amount) expression and need to show the rows only sum(amount)>1000 with out set analysis.

is there any other option..?

ariel_klien — Wed, 24 Jul 2013 05:35:56 GMT

You can try:

if(sum(amount)>1000,sum(amount),null())

Ariel

Wed, 24 Jul 2013 05:42:38 GMT

try this

if(sum(amount)>1000,sum(amount),' ')

or try this

if(sum(amount)>1000,sum(amount),0)

er_mohit — Wed, 24 Jul 2013 05:48:58 GMT

try this

sum(if(amount>1000,amount,0))

and make sure in presentation tab check on supress null value

the other way to do this on dimension tab write there for one dimension

in add calculated dimension that

aggr(if(amount>1000,Dimensionfield),Dimensionfield))

in label side write the name of Dimensionfield

make sure check on suppress null value

padmanabhan_ram — Wed, 24 Jul 2013 08:25:27 GMT

if you can perform it in the script level then try using Set HidePrefix = %;

and use %field name in the expression.. hope this helps you.