topic Re: Change data in calendar field after selection in QlikView

Change data in calendar field after selection

Wed, 25 Nov 2020 16:16:04 GMT

I created two calendar objects 'From'(Min=min(InvoiceDate,Max=EndDate), 'To'(min=StartDate,Max=Max(InvoiceDate))

Created two trigger action for InvoiceDate( ='>='& StartDate& '<='& EndDate )

When I want to choose another date or reselect sometimes I'm unable to do it, especially with To-field. (after clear all I can) But:

If my first selection is for From-field I can't(never) do selection for To-field. So what's wrong? How to fix it? If you have any examples, please send it.

Re: Change data in calendar field after selection

Anil_Babu_Samineni — Sat, 18 Mar 2017 01:53:09 GMT

Sometimes, The functionality is not work as we hit. This is the case, can you let us know which object you took to selection. May be Calendar object helps you. In fact, You should call up them(Variables).

FYI, Look here Selecting Arbitrary Date Ranges - YouTube

Re: Change data in calendar field after selection

Sat, 18 Mar 2017 11:25:22 GMT

I saw this video and can say that everything is same except for objects: I took calendar objects, not just input boxes.

Re: Change data in calendar field after selection

Sat, 18 Mar 2017 15:09:00 GMT

Changed Min and Max dates for =min({1}InvoiceDate) and =max({1}InvoiceDate) and now it's ok, but what does {1} mean? Without {1} situation doesn't improve.

And now I can choose invalid date ranges, but I'll fix it later.