topic Re: Showing all values except NULL in QlikView

Showing all values except NULL

Tue, 05 Aug 2014 06:25:17 GMT

I have a chart where I want to show last 12 Months on the X axis everytime,even if no data is available. I have used the 'Show all values' in the Dimension tab. However this also shows a NULL value sometimes(when no data is available). I have checked the option 'Suppress when value is NULL' but it doesnt make any difference. Is there any way to hide this null value?

Re: Showing all values except NULL

aveeeeeee7en — Tue, 05 Aug 2014 06:31:20 GMT

use {1} in your expression. It will show all data.

like this:

Sum({1}Amount)

Regards

Aviral Nag

Re: Showing all values except NULL

amit_saini — Tue, 05 Aug 2014 06:32:57 GMT

Try something like below:

where Your_field_name <> ''; (Use in script)

=If( Your_field<>0,Your_field,null()) ( Use in Expression)

Thanks

Re: Showing all values except NULL

sujeetsingh — Tue, 05 Aug 2014 06:45:33 GMT

Try supress null on Presentation tab

Re: Showing all values except NULL

Tue, 05 Aug 2014 06:45:48 GMT

Thanks. I used it in the expression, and its working now