topic Re: straight table cal condition message when no data in QlikView

straight table cal condition message when no data

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

Hi Experts,

I have straight table has some list of rows. The chart shows just chart skeleton with nulls, when it has no data for the user selection.

My requirement is to show a message in the chart when there is no data for the user selections.

I thought to create a calculated condition, but not sure which field to put there as user can do selection on any listbox for which chart may have no data.

Please help

Re: straight table cal condition message when no data

vishsaggi — Tue, 29 Aug 2017 14:43:32 GMT

May be create a flag in your script and use that calculated filed in our condition. Like

IF(Len(Trim(YourfieldName1)) =0 OR

Len(Trim(YourfieldName2)) =0 OR

Len(Trim(YourfieldName3)) =0 OR

..... = 0, 0, 1) AS ExistDataFlag

This would be just one time creation in your script.

Re: straight table cal condition message when no data

vinieme12 — Tue, 29 Aug 2017 15:43:51 GMT

What is the Dimension in your Chart?

What is the expression in your Chart?