Ad-Hoc Report

[soha1902]

Hi All,

I have implemented Ad-hoc report in my qvw. It is working fine. When I select a dimension and a metric then it will populate the report.

Just want to know for my some metric there is no dimension available, in this case it will give following output:

                                                                     Region               Royalty

                                                                      -                          10,000

I need to avoid these kind of situation, Instead of this I want to show one friendly message. 'No data available for selected fields'.

How I will get this??

Can anyone help me.

Thanks.

[vikasmahajan]

in load script  where region is loaded you can check the values of region if there is no value you can take 'Unclassified'  like this.

if(ISNULL(Region) OR LEN(Region)=0,Unclassified,0)) AS Region,

Hope this helps

Vikas

[Anonymous]

Hi,

Alternatively, you can go to properties->presentation and change the null symbol to something you want. Please see below image. Just choose the dimension you want.

[soha1902]

Hi Vikas,

Thanks for your reply, I don't want to give any name for null values like 'Unclassified'. Simply What I want if dimension value is not available for selected metric then It will show the message like "No data is available for selected fields".

[vikasmahajan]

You can set error message in calculation condition unfulfilleded to !  Vikas

[settu_periasamy]

as Vikas said, you can try with Nullcount function in the Calculated condtion..

=NullCount(Region)=0 and NullCount(OtherField)=0

[Mahamed_Qlik]

Hi Soha,

This can be achieve in following ways :

I am assuming that, you have already created inline table for the dimension in the script.

So, In straight table which you are using as object to show the report, just create the one calculated dimension

Region and put the expression as below:

=if(Isnull(Region),'Type you message to pop up',Region)

For more info please find the attached copy of sample report.

Hope it helps you out and if you found as correct answer then mark it as correct and close the trail.

Have a nice day.

Regards, !

Mark