topic Re: Ad-Hoc Report in QlikView

Ad-Hoc Report

soha1902 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Ad-Hoc Report

vikasmahajan — Tue, 19 Apr 2016 06:31:08 GMT

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

Re: Ad-Hoc Report

Anonymous — Tue, 19 Apr 2016 06:42:01 GMT

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.

Re: Ad-Hoc Report

soha1902 — Tue, 19 Apr 2016 06:59:37 GMT

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".

Re: Ad-Hoc Report

vikasmahajan — Tue, 19 Apr 2016 07:05:51 GMT

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

Re: Ad-Hoc Report

settu_periasamy — Tue, 19 Apr 2016 07:15:09 GMT

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

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

Re: Ad-Hoc Report

Mahamed_Qlik — Tue, 19 Apr 2016 07:43:43 GMT

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