topic Re: No data to display in QlikView

No data to display

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

Hi all

When we don't have any data which meets expression condition in chart, we get "No data to display".

Can we export this message to any variable?

Any leads?

Thanks

Shivesh

Re: No data to display

kaushiknsolanki — Mon, 19 Feb 2018 06:50:07 GMT

HI,

You can create a variable which has same expression condition which you have given on chart and then set the text which you want if condition is not fulfill and use that variable wherever you want.

Regards,

Kaushik Solanki

Re: No data to display

shiveshsingh — Mon, 19 Feb 2018 07:05:06 GMT

Thanks for your response,

i couldn't understand this statemen..

then set the text which you want if condition is not fulfill and use that variable wherever you want.

Re: No data to display

kaushiknsolanki — Mon, 19 Feb 2018 07:16:10 GMT

Let us assume that you have condition as below.

Getselectedcount(Field)=1

Then your variable should have like below expression.

If(Getselectedcount(Field)<>1,'Condition Not matched','Condition Matched');

Hope its clear.

Regards,

Kaushik Solanki

Re: No data to display

shiveshsingh — Mon, 19 Feb 2018 10:18:48 GMT

Hi Kaushik

Here i don't want to use expression as i am having lots of expression in the chart.

Can we have some other way for this?

Thanks