Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Null Symbol in Bar chart

Hi ,

i need to represent the null values as unclassified in bar chart and when i am checking the null values in dimension it showing on the desktop but not on the client .

Dimension:

If(Len(Trim([CustRating Quantitative_Summary])) = 0,'Unclassified',[CustRating Quantitative_Summary])

View on Desktop :

Capture _Bar_Desktop.JPG.jpg

View on Access Point:

Capture_bar.JPG.jpg

Thanks & Regards,

Saurabh

Tags (5)
27 Replies
ecolomer
Honored Contributor II

Re: Null Symbol in Bar chart

Try to select the option "Supress when the value is null" in the options of dimension

Not applicable

Re: Null Symbol in Bar chart

Hi Enrique,

Thanks for the reply!

i dont want to suppress the null values in dimension . Null values in the dimension should be named as Unclassified.

Regards,

Saurabh

amit_saini
Honored Contributor III

Re: Null Symbol in Bar chart

Saurabh,

Go to chart properties-> Dimension-> and checked "Suppress When Value is Null" option

Thanks,

AS

ecolomer
Honored Contributor II

Re: Null Symbol in Bar chart

Try this:

=if(IsNull(If(Len(Trim([CustRating Quantitative_Summary])) = 0,'Unclassified',[CustRating Quantitative_Summary])), 'Unclassified', If(Len(Trim([CustRating Quantitative_Summary])) = 0,'Unclassified',[CustRating Quantitative_Summary]))

Not applicable

Re: Null Symbol in Bar chart

Not Working

Thanks

sujeetsingh
Honored Contributor III

Re: Null Symbol in Bar chart

Supress null or represent it as unknown.

ecolomer
Honored Contributor II

Re: Null Symbol in Bar chart

Try now


=if(IsNull(If(Len(Trim([CustRating Quantitative_Summary])) = 0,'Unclassified',[CustRating Quantitative_Summary]))

sasikanth
Valued Contributor III

Re: Null Symbol in Bar chart

Hi saurabh ,

try to implement the same logic in the back end script

LOAD *,

if(not isnull(([CustRating Quantitative_Summary]),([CustRating Quantitative_Summary],'UnClassified') as SR_QS,

.

.

FROM ........

Thnaks

Sasi

Not applicable

Re: Null Symbol in Bar chart

Hi Sasi ,

Thanks for reply .

its showing the Unclassified on qv desktop but  when i check same chart on accesspoint ,in place of unclassified its displaying '-'.

Regards,

Saurabh