topic Re: Do not show null values in table in QlikView

Do not show null values in table

Fri, 12 Dec 2014 15:34:17 GMT

Hello,

I have a table in qlikview that has columns DAY, TOPIC, DISCUSSION. I would like to have it so that if there is no value in the DISCUSSION field then it will not display the DAY and TOPIC fields that go along with it. How would i go about doing this?

Thanks,

Re: Do not show null values in table

Fri, 12 Dec 2014 15:36:58 GMT

Hi Brandon,

If these are dimensions then you have the option to suppression null values in the chart.

hope that helps

Joe

Re: Do not show null values in table

yduval75 — Fri, 12 Dec 2014 15:38:15 GMT

In a straight table, you can put in your expressions

If(len(DISCUSSION) > 0, Only(DAY))

If(len(DISCUSSION) > 0, Only(TOPIC))

or put Day and Topic in dimension and Disucussion in expression with suppress null values in presentation tab.

Re: Do not show null values in table

Wed, 17 Dec 2014 16:36:34 GMT

I'm having a hard time figuring this out. I put in the above code...

If(len(DISCUSSION) > 0, Only(DAY))

If(len(DISCUSSION) > 0, Only(TOPIC))

in the general tab under calculated condition and nothing worked. I also tried it under the sort tab and it didnt work. Where is the expression supposed to go? I also checked the omit rows where field is null under presentation and it doesnt hide the rows

Re: Do not show null values in table

anbu1984 — Wed, 17 Dec 2014 16:50:15 GMT

Expression: If(len(DISCUSSION) > 0, Your_expression)