Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sivarajs
Specialist II
Specialist II

select in field not selecting dates

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

3 Replies
datanibbler
Champion
Champion

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.

sivarajs
Specialist II
Specialist II
Author

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)

its_anandrjs
Champion III
Champion III

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

Regards

Anand