topic Suppress Rows in Chart if Expression is zero? in QlikView

Suppress Rows in Chart if Expression is zero?

Thu, 01 Dec 2011 16:07:26 GMT

Hi,

I have a straight table chart with some calculated expressions. I would like to conditionally suppress the rows where the expression value is zero. Is this possible?

Thanks,

Magnus

Suppress Rows in Chart if Expression is zero?

richard_chilvers — Thu, 01 Dec 2011 16:43:28 GMT

In the chart tab called Presentation, there is an option (for each expression) to Suppress Zero-values.

If this is option is ticked for each expression in the row, my experience is that the row is not shown.

Regards

Suppress Rows in Chart if Expression is zero?

Fri, 02 Dec 2011 08:11:18 GMT

Thank you. That may be true, but my problem in this case is that not all expressions are zero or null values. Any other ideas?

Best regards,

Magnus

Suppress Rows in Chart if Expression is zero?

jagan — Fri, 02 Dec 2011 12:23:41 GMT

Hi,

Please let me know my understanding is correct,

If one particular expression value is 0, then you should hide that row?

If that is the requirement then do the following

Expression 1 = Sum(Value1), If this value is 0, then we will hide the entire row

Expression 2 = If([Expression 1] = 0, 0, Sum(Value2))

Expression 3 = If([Expression 1] = 0, 0, Sum(Value3))

If all the expression values are 0, then the row is not displayed.

Hope this helps you.

Regards,

Jagan.

Suppress Rows in Chart if Expression is zero?

Mon, 05 Dec 2011 10:53:29 GMT

Thanks, worked perfectly. I created a new expression "Show", which gets value 1 or zero depending on other expressions.

Magnus