topic need to display only null values in chart in QlikView

need to display only null values in chart

Srinivas — Tue, 16 Feb 2016 04:40:34 GMT

Hi All,

We need to display only null values in fronted chart,this is the requirement according to that i have created, for i wrote below expression

(if(IsNull([Product Number])=-1 ,'' , Null()) , I can find all null values ,But some product still shows values those are 950093 ,552825 ,552824 and 552823 this wrong , my answer is if have value we need to hide that entire row Please below screen shot.

Could you please help me.

Advance Thanks

Munna

Re: need to display only null values in chart

Chanty4u — Tue, 16 Feb 2016 04:45:34 GMT

try

=if(len(trim([Product Number]))=-1, 'Null())',

Re: need to display only null values in chart

jagan — Tue, 16 Feb 2016 04:57:17 GMT

Hi,

Try this expression, no need of calculated dimension

=Sum({<[Product Number]-={'*'}>} MeasureName)

Note: Replace MeasureName with your actual field name.

REgards,

jagan.

Re: need to display only null values in chart

tamilarasu — Tue, 16 Feb 2016 05:01:52 GMT

Hi,

You can try,

=If(Len(Trim([Product Number]))=0,'')

Re: need to display only null values in chart

sasikanth — Tue, 16 Feb 2016 05:11:14 GMT

HI,

Try this expression

Sum({1-<[Product Number]={'*'}>}Measure)

Re: need to display only null values in chart

Chanty4u — Tue, 16 Feb 2016 05:17:09 GMT

and give

SET Nullvalue = '';

NULLASVALUE *;

Re: Null values in tables

Re: need to display only null values in chart

pavan045 — Tue, 16 Feb 2016 06:47:35 GMT

Hi Srinivas,

what is the name of the first column in your table??..if that first column is any key for that table (if not a measure), then use below expression instead of your first column as caluculated dimension.

(if(IsNull([Product Number])=-1 ,'your first column name here')

Hope this will help..