topic Re: Clear variable when Field is cleared in QlikView

Clear variable when Field is cleared

Tue, 10 Jun 2014 10:41:06 GMT

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.

Re: Clear variable when Field is cleared

Tue, 10 Jun 2014 18:31:21 GMT

Instead, maybe create a button that clears all three of those at once through three actions?

Re: Clear variable when Field is cleared

Wed, 11 Jun 2014 07:45:56 GMT

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.

Re: Clear variable when Field is cleared

michael_maeuser — Wed, 11 Jun 2014 07:50:35 GMT

does it work for you if you put in your variables if(getselectedcount(Date)>0, datefrom)?

Re: Clear variable when Field is cleared

SergeyMak — Wed, 11 Jun 2014 08:06:56 GMT

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

Re: Clear variable when Field is cleared

Wed, 11 Jun 2014 08:25:12 GMT

This example isn't working for me?

Re: Clear variable when Field is cleared

michael_maeuser — Wed, 11 Jun 2014 08:27:36 GMT

did you try this variable =if(getselectedcount(Date)>0, datefrom)?

datefrom should reflect your current datefrom variable expression

Re: Clear variable when Field is cleared

SergeyMak — Wed, 11 Jun 2014 08:28:07 GMT

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.

Re: Clear variable when Field is cleared

Wed, 11 Jun 2014 08:40:06 GMT

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.

Re: Re: Clear variable when Field is cleared

Wed, 11 Jun 2014 08:45:43 GMT

Could you please see the sample document and advise how I would implement your proposed solution?

Thanks for your time.

James.

Re: Re: Clear variable when Field is cleared

Wed, 11 Jun 2014 08:46:29 GMT

Please see my attached document, could you see how I would implement your solution? I can't seem to get yours working in my environment.

Re: Re: Re: Clear variable when Field is cleared

SergeyMak — Wed, 11 Jun 2014 08:50:35 GMT

PFA

In my opinion it works

Re: Clear variable when Field is cleared

Wed, 11 Jun 2014 08:52:59 GMT

Thanks Sergey,

it's now working my example document- must be something weird going on in my actual document because it still isn't working there.

you've answered the problem though so have marked you as correct.

James.

Re: Clear variable when Field is cleared

SergeyMak — Wed, 11 Jun 2014 08:58:14 GMT

You can share your original application.

But probably you need to reduce (File\Reduce Data) and Scramble data (Settings\Document Properties\Scrambling - select some fields and click Scramble)

Re: Re: Clear variable when Field is cleared

Wed, 11 Jun 2014 09:19:03 GMT

Ok Sergey, let's see you solve this one.

Why the hell isn't it working in this document?

Re: Re: Re: Clear variable when Field is cleared

SergeyMak — Thu, 12 Jun 2014 04:04:27 GMT

So. it works as well

I added trigger for a field Omniture.Date OnSelect

Set Variable dateFrom with value =IF(GetSelectedCount(Omniture.Date)=0 AND GetSelectedCount(Omniture.Date)=0,Null(),dateFrom)

Set Variable dateTo with value =IF(GetSelectedCount(Omniture.Date)=0 AND GetSelectedCount(Omniture.Date)=0,Null(),dateTo)

PFA