topic Re: Trigger to clear previous date selection in QlikView

Trigger to clear previous date selection

linoyel — Mon, 20 Jan 2014 13:24:45 GMT

Hi,

In my sheet a user can select either dates (from and to) in the Calendar Object, or he can select Date from separate List Box.

I managed to connect the Calendar Object selections to the Date List Box, so when a user pics From and To dates from the Calendar, in Current Selections box it shows: Date ='>=' &_DateFrom & '<=' & _DateTo (the On Select Trigger).

Now, after this, a user for example wants to select a specific date from Date List Box. Current Selections Box updates in a right way, but the Calendar Object remains with previous selections.

I need a trigger which will erase those selections if the user selects date from Date List Box.

Thank you!

Re: Trigger to clear previous date selection

maxgro — Mon, 20 Jan 2014 14:07:45 GMT

Try with a document trigger

Menu --> Settimgs --> Document Properties --> Field Event Triggers --> Choose Date field --> On Select --> Add Actions)

The trigger should be

Action Type: External

Actions: Set Variable

Variable: _DateFrom

Value: =null() // =min(Date)

And add the same action for _DateTo

Re: Trigger to clear previous date selection

linoyel — Mon, 20 Jan 2014 15:17:12 GMT

It's not working because the field _DateFrom and _DateTo in the Calendar are already triggered:

DateFrom<Has Action(s)> --> on select --> (Actions)Select in Field --> (Field) Date --> (Search String) ='>=' &_DateFrom & '<=' & _DateTo

Meaning when user selects something in Calendar he actually selects values from Date field.

I need the reverse action - if user selects values in Date field - I want the previous selection in Calendar (if was) to be emptied

Re: Trigger to clear previous date selection

jerem1234 — Mon, 20 Jan 2014 15:52:00 GMT

Looks like your DateFrom and DateTo are fields? Then you would want to set the trigger in your document properties for your field 'Date'. Using OnSelect, add 2 actions of

Clear Field -> (Field) _DateFrom

Clear Field -> (Field) _DateTo

So when you select the dates in your listbox, it will clear your To and From dates.

Hope this helps!

Re: Trigger to clear previous date selection

Anonymous — Mon, 20 Jan 2014 16:48:10 GMT

Linoy Barnea,

Looks like you have a logical loop.

Selection in _DateTo (_DateFrom) triggers selection in Date. That means, if selection in Date changes _DateTo (_DateFrom), they in turn select Date, which you don't want.

A simple solution is to remove triggers from the _DateTo and_DateFrom fields, and instead add a button "Apply Date Range". So, selections in _DateTo (_DateFrom) don't do anything until you click the button. Besides, it helps to avoid selection before both ends of the range are defined. Just add trigger from jerem1234

Regards,

Michael

Re: Trigger to clear previous date selection

stevedark — Mon, 20 Jan 2014 17:23:05 GMT

Hi Linoy,

I often find that when you want to and from dates it is easier and more robust to implement these using variables. This way the variables are not affected by selections and you can simply apply the range using Set Analysis.

I've uploaded an example of how you can manipulate those date variables using actions on buttons here:

QlikView App: Using Actions To Change Date Variables

Hope that helps,

Steve

Re: Re: Trigger to clear previous date selection

Anonymous — Mon, 20 Jan 2014 17:30:41 GMT

Steve, can't disagree with that. Variables are usually more suitable for this sort of task.

Linoy,

If you don't like simple solutions, see attached. It uses macro though, and a variable too but in a different way.

Regards,

Michael

Re: Trigger to clear previous date selection

linoyel — Tue, 21 Jan 2014 13:27:44 GMT

Thanks a lot, that worked!!

Re: Trigger to clear previous date selection

linoyel — Tue, 21 Jan 2014 14:22:51 GMT

Hi Michael, what do you mean by saying - add a button "Apply Date Range"?

Re: Trigger to clear previous date selection

linoyel — Tue, 21 Jan 2014 14:28:41 GMT

Hi Steve, thanks for showing an interesting implementation of choosing dates using variables.

I'll probably use it somewhere in the future.

In my case, though, I don't understand how it will help because in my sheet a user can select either date range from Calendar, or Day, Month, Year or Date separately (these are all fields), and what I wanted to do is to connect the selection of separate fields to Calendar object. Well, implementing the "Clear Field" trigger solved my issue.

Re: Trigger to clear previous date selection

Anonymous — Tue, 21 Jan 2014 15:29:17 GMT

I mean to remove all actions from the _DateTo and_DateFrom fields, and instead add a button, and create "select in Date" action there. It may be useful in addition to the solution you have already.

Re: Trigger to clear previous date selection

stevedark — Tue, 21 Jan 2014 15:53:44 GMT

As Michael as also said dates can be much more easily applied in expressions when they are coming from variables. If you want the user to select dates by using separate fields and these separate fields need to be applied in various ways you can achieve this by having your calendar in a data island (eg. don't join it to anything else) and then have variables that pick values from that data island, eg. a variable vMaxDate that contains =max(Date).

I've a couple of examples uploaded to QlikCommunity looking at applying dates in Set Analysis, for prior period compare, but similar code could be applied for implementing a range.

It sounds that your initial problem is fixed, but hopefully these other approaches may give you something to consider in future.

-Steve

Re: Trigger to clear previous date selection

linoyel — Thu, 23 Jan 2014 08:29:06 GMT

Steve, I'm looking now at your "At The Qlik of a Button" presentation, and I'd like to implement it in my work.

In my case it's a bit different: I have a List Box with 4 values, and I want to show a chart I've built only when user picks a certain value from that List. How can I implement that using variables?

Re: Trigger to clear previous date selection

stevedark — Thu, 23 Jan 2014 09:17:21 GMT

Hi Linoy,

If it makes sense to have a list box, perhaps as a data island, with those four values in you don't need to use variables. Just have a Show Condition on each chart something like:

=Only(ListBoxName) = 'Chart1'

You would then need a text box to show when more than one option was picked in the list box, to advise that an option must be made, the Show Condition on that would be:

=GetPossibleCount(ListBoxName) <> 1

If you want to do the same using variables, as I would tend to do, you would need to set up four text boxes, each with an action to set a variable to a value, and then the Show Condition would be:

=vShowWhichChart = 'Chart1'

Another QlikCommunity example I have uploaded shows show and hid functionality with variables:

QlikView App: Show and Hide Windows Dynamically

The document on Buttons is backed with a blog post and video, and can be found here:

QlikView App: At The Qlik Of A Button

Hope that helps. Please post back if you have any more specific questions on implementing this.

Steve

Re: Trigger to clear previous date selection

linoyel — Thu, 23 Jan 2014 10:05:36 GMT

WOW!

The " =Only(ListBoxName) = 'Chart1' " works amazing!

When multiple values are selected, you wrote to build a text box "to advise that an option must be made" - what do you mean? Should I write in the Text Box that a user must pick only one value? And what if I want to show the chart if at least (not only) one of the relevant selections has been made?

Another thing: I guess I'm missing something in understanding the connection between 4 Text Boxes and 4 values in the List Box. My List Box is not a data island, it's connected to lots of tables and when a user picks one of the values there, he gets information on that selection. If I would like to set Text Boxes instead of each one of the values of the original List Box, how would I connect a Text Box selection to the information which is supposed to be presented on that selection?

Re: Trigger to clear previous date selection

stevedark — Thu, 23 Jan 2014 10:48:29 GMT

If you have a space on the screen where you have hidden an object you ought to put something else in it's place. The simplest approach is a Text Box with text on, saying something like 'Your Selections Must Include Chart 1 To View This Chart' and then the show condition would be the opposite of what you have on the chart, eg:

=Only(ListBoxName) <> 'Chart1'

The other approach is not to use the Show Conditional, but go for the Calculation Condition instead (on the General tab) you can then set an Error Message for the Calculation Condition Not Set error, and put your text there.

To show an object when any one of a number of selections includes the right one you could do this:

=maxstring({<ListBoxName*={'Chart1'}>}ListBoxName) = 'Chart1'

This is basically checking for Chart1 in any of the values using Set Analysis, if Chart1 doesn't appear in the list then Null will be returned by the maxstring function.

The four text boxes with actions that I referenced were regarding an approach that didn't use listbox values. If the toggle you want is not directly related to the data - rather just user selection - then I find buttons and variables a better approach. It doesn't sound like that is the case for you?

Cheers,

Steve

Re: Trigger to clear previous date selection

linoyel — Thu, 23 Jan 2014 13:05:02 GMT

Steve, thanks for your help and the examples, I've tried all you've presented and it worked

In my case user selections actually are related to data, so I understand I have to stay with List Boxes meanwhile.

The " only([Tran Type]) = 'Declined' " was exactly what I was looking for to implement.