topic Re: select in field not selecting dates in QlikView

select in field not selecting dates

sivarajs — Tue, 02 Dec 2014 12:31:44 GMT

Hi,

I have a date range selection (vstartdate and venddate) to select values in a field and a button has select in field action to select the field.

The problem is when am selecting a date range that is not in fields list, am not getting any effect in the chart when clicking the button. For this range i want to show my chart as blank. Is there a work around to acheive this?

i need to show chart as blank when the date range in not available after clicking on select in field action.

Sivaraj

Re: select in field not selecting dates

datanibbler — Tue, 02 Dec 2014 12:35:32 GMT

Hi Sivaraj,

try in a textbox_object whether the ISNULL() function returns any value - should be -1 or 0 - when you select a date that is not in your list.

Re: select in field not selecting dates

sivarajs — Tue, 02 Dec 2014 12:42:35 GMT

Now its showing -1

For your info, am not selecting date directly from the list.am using select in field action button to select. If the date range selected is not available in the list the button itself not showing any progress (click itself not happening)

Re: select in field not selecting dates

its_anandrjs — Tue, 02 Dec 2014 12:43:19 GMT

Try to use the Suppress When Value is null option in the chart.

Regards

Anand