topic Re: Suppress When expression with text in QlikView

Suppress When expression with text

renjithpl — Sun, 23 Jul 2017 19:22:47 GMT

Hi All,

Suppose this is an output in a straight table

I want to suppress the IDs with all Null values and also with N/A's

Since I have text (N/A) in the expression, ID 4 still shows up after i checked "Suppress When Values is Null"

Any idea?

Renji

sergio0592 — Sun, 23 Jul 2017 19:34:26 GMT

And if you try with :

sum({<ID={"=sum(CurrSales)>0"} > } CurrSales)

sum({<ID={"=sum(PrevSales)>0"} > } PrevSales)

renjithpl — Sun, 23 Jul 2017 19:54:34 GMT

I have a condition to show that,

if (isnull(CurrSales), 'N/A', sum({<ID={"=sum(CurrSales)>0"} > } CurrSales))

Anil_Babu_Samineni — Mon, 24 Jul 2017 01:23:37 GMT

Try to make it as Data planning / Mock up application. That may useful to explain clearly due to N/A in your application.