topic Re: Null Symbol in Bar chart in QlikView

Null Symbol in Bar chart

Thu, 25 Sep 2014 03:15:40 GMT

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 :

View on Access Point:

Thanks & Regards,

Saurabh

Re: Null Symbol in Bar chart

ecolomer — Thu, 25 Sep 2014 03:35:43 GMT

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

Re: Null Symbol in Bar chart

Thu, 25 Sep 2014 04:06:30 GMT

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

Re: Null Symbol in Bar chart

amit_saini — Thu, 25 Sep 2014 04:07:25 GMT

Saurabh,

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

Thanks,

Re: Null Symbol in Bar chart

ecolomer — Thu, 25 Sep 2014 04:11:49 GMT

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]))

Re: Null Symbol in Bar chart

Thu, 25 Sep 2014 04:16:59 GMT

Not Working

Thanks

Re: Null Symbol in Bar chart

sujeetsingh — Thu, 25 Sep 2014 04:19:23 GMT

Supress null or represent it as unknown.

Re: Null Symbol in Bar chart

ecolomer — Thu, 25 Sep 2014 04:23:09 GMT

Try now

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

Re: Null Symbol in Bar chart

sasikanth — Thu, 25 Sep 2014 04:24:18 GMT

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

Re: Null Symbol in Bar chart

Thu, 25 Sep 2014 04:30:37 GMT

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

Re: Null Symbol in Bar chart

sasikanth — Thu, 25 Sep 2014 04:39:05 GMT

Have you tried the logic at script level ?

Re: Null Symbol in Bar chart

sundarakumar — Thu, 25 Sep 2014 04:57:51 GMT

I can see u are using a drillown there. have u created it in

doc properties -> groups -> edit (the particular dim)?

better push it to back end...

If u have pushed it to back end as described by sassikanth then u would not see a null there..

-Sundar

Re: Null Symbol in Bar chart

PrashantSangle — Thu, 25 Sep 2014 05:00:23 GMT

Hi,

In dimension tab->Un Select Supress when value is Null

and select-> Show All Values.

Delete that object and recreate it.

Regards

Re: Null Symbol in Bar chart

jyothish8807 — Thu, 25 Sep 2014 05:28:46 GMT

Hi,

Try writing the expression in script instead of chart and select show all values and un select supress when value is Null.

Regards

Re: Null Symbol in Bar chart

Thu, 25 Sep 2014 06:40:27 GMT

Hi Saurav

It works fine .try to download IE plugin

Re: Null Symbol in Bar chart

Thu, 25 Sep 2014 08:15:19 GMT

Hi shweta ,

Not Working .

Regards,

Saurabh

Re: Null Symbol in Bar chart

sathishkumar_go — Thu, 25 Sep 2014 08:20:08 GMT

Hi Saurabh,

Can u republish the application and try it!

-Sathish

Re: Null Symbol in Bar chart

annafuksa1 — Thu, 25 Sep 2014 08:20:29 GMT

Can you share your app ?

Re: Null Symbol in Bar chart

annafuksa1 — Thu, 25 Sep 2014 08:24:22 GMT

Try this settings

Re: Null Symbol in Bar chart

Anonymous — Thu, 25 Sep 2014 08:30:26 GMT

Hi Saurabh,

I also had issue but that was like in Pivot and straight table separating line were not appearing that was because of browser issue they were trying to access app in chrome, But on IE it worked.

Try this if it is helpful.

Thanks