Suppress row when expression returns null

Fri, 22 Mar 2013 11:59:33 GMT

Hi,

I have to implement the following logic

Roll Rate = Current Month(Amount1)/Previous Month(Amount2).

This has to be displayed for 13 months. I have implemented the below expression

sum({< [Month Start Number] = {"<=$(=max([Month Start Number])) > $(=max([Month Start Number])-395)"}>}Amount1) /

Above(sum({<[Month Start Number]={"<=$(=max([Month Start Number])-30)>$(=max([Month Start Number])-426)"}>}Amount2))

The expression is working but i am getting an extra row with null value since the expression returns null for one month. How can i suppress this row? I have tried suppress null option but this is not working.

Thanks

Re: Suppress row when expression returns null

sushil353 — Fri, 22 Mar 2013 12:03:56 GMT

Check your presentation tab> supress missing and there is some other options too...

topic Suppress row when expression returns null in QlikView

Suppress row when expression returns null

Re: Suppress row when expression returns null