topic Re: No Data to display in QlikView

No Data to display

varunreddy — Tue, 24 Nov 2015 15:16:55 GMT

Hi All,

I have a calculated dimension. If the filter doesn't match the calculation, the report is displaying "No data to display". I want to change the content to be "Please select apprpriate Date".

Can anyone please guide me?

Calculation Used:

=Aggr(Only({<[Pull Type] = {'M'}> + <[As of Date] = {"$(vmaxDate)"}>} [As of Date]),[As of Date] )

If I select date other than maximum date, calculation dimension is getting failed. Is there a way to disregard the filter? If no, then is there a way to change the error message?

Cheers,

Varun

Re: No Data to display

manojkulkarni — Tue, 24 Nov 2015 15:22:00 GMT

You can set Error Messages for calculation conditions . General Tab of Chart Properties - Error Messages - Set required Message for calculation condition unfulfilled.

Re: No Data to display

sinanozdemir — Tue, 24 Nov 2015 15:22:22 GMT

Hi Varun,

In the general tab of the chart properties, you can customize the error message and the calculation conditions:

In terms of ignoring filters, you can add 1 in the set analysis:

=Aggr(Only({1<[Pull Type] = {'M'}> + <[As of Date] = {"$(vmaxDate)"}>} [As of Date]),[As of Date] )

Re: No Data to display

varunreddy — Tue, 24 Nov 2015 15:23:48 GMT

Hi Sinan,

I only want to ignore [As of Date]

Re: No Data to display

varunreddy — Tue, 24 Nov 2015 15:24:58 GMT

I tried, but it is not working. As this is calculation condition, it is not working. Any help?

Regards,

Varun

Re: No Data to display

Tue, 24 Nov 2015 15:49:35 GMT

are you sure you are changing the correct message. Tjhere are many messages in the list and you have to select the one you want to change

Re: No Data to display

varunreddy — Tue, 24 Nov 2015 15:51:13 GMT

Hi Adam,

I only have these options

Tried to change for each and every option. But yhis is not working

Re: No Data to display

varunreddy — Tue, 24 Nov 2015 17:46:18 GMT

Hi Sinan,

Can you send any sample?

Regards,

Varun