Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have followed this guide: http://www.learnqlickview.com/dynamic-calendar-widget-in-qlikview/
and have a document setup like above.
When I clear my "Date" field, I would like to also clear the dateFrom and dateTo variables, but how can I achieve this?
Otherwise, when you clear the date field- the calendar object still has the old dates- which can easily fool a user.
James.
Instead, maybe create a button that clears all three of those at once through three actions?
Hi Robert.
That works, but is not very user friendly- have a clear button on the page, and an offical clear all button (that doesn't clear all) on the toolbar.
This is a Qlikview feature I think should really be implemented, an "on clear" trigger.
does it work for you if you put in your variables if(getselectedcount(Date)>0, datefrom)?
Hi,
I used OnSelect trigger for Calendar.Month Field
=IF(GetSelectedCount(Calendar.Month)=0 AND GetSelectedCount(Calendar.Year)=0,Null(),vDateTo)
=IF(GetSelectedCount(Calendar.Month)=0 AND GetSelectedCount(Calendar.Year)=0,Null(),vDateFrom)
Probably you need it also for Calendar.Year
PFA an example
This example isn't working for me?
did you try this variable =if(getselectedcount(Date)>0, datefrom)?
datefrom should reflect your current datefrom variable expression
I don't know
But it's working if I clear selections with Clear button or just deselect month.
In this example there are no date, only month, year. But you can use it with small changes.
Yeah I have, doesn't seem to work when I place this in the field trigger.
I've been testing it- for some reason it's not 'activating' when I clear all, it will update when I choose a new date, but simply wont clear the var for some reason.
I think it has something to do with me setting the date based on the link above, and not simply a selection in a list box.
edit: gimmie 15 mins, I'm gonna have to get a sample document up.
Could you please see the sample document and advise how I would implement your proposed solution?
Thanks for your time.
James.