Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to select the option "Supress when the value is null" in the options of dimension
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
Saurabh,
Go to chart properties-> Dimension-> and checked "Suppress When Value is Null" option
Thanks,
AS
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 Working
Thanks
Supress null or represent it as unknown.
Try now
=if(IsNull(If(Len(Trim([CustRating Quantitative_Summary])) = 0,'Unclassified',[CustRating Quantitative_Summary]))
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
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