topic Re: Trigger with 2 conditions on date in QlikView

Trigger with 2 conditions on date

Wed, 26 Nov 2014 09:47:10 GMT

Hi,

I would like help concerning this point.

On my project I put one input field to select a list of dates.

The date selected should have 2 possibilities:

date>=2014-11-26 or date = 1940-01-01

But i don't find how writing this script on Qlikview.

Any help with the above will be much appreciated.

Regards,

Marcel

Re: Trigger with 2 conditions on date

Anonymous — Wed, 26 Nov 2014 09:54:26 GMT

Hi Marcel

try using where condition while loading the data from the file

where date=1940-01-01 or date>=2014-11-26

Regards

Harsha

Re: Trigger with 2 conditions on date

Wed, 26 Nov 2014 10:09:09 GMT

Hi Sriharsha,

Thanks for your answer but i would like to update my view after the loading of the data.

My function works well with one condition: ='>=2014-11-26'

But I don't know how add the second condition on this exemple.

Regards

Marcel

Re: Trigger with 2 conditions on date

giacomom — Wed, 26 Nov 2014 10:23:34 GMT

Hi Marcel,

you can edit the properties of your input box like in the attached figure so the drop down list will show only the values in the date range you want.

Regards,

Giacomo

Re: Trigger with 2 conditions on date

Wed, 26 Nov 2014 12:53:43 GMT

Hi Giacomo,

Thank you for your answer, but it was not exactly what I wanted to do.

I would like when a user will write a date on the field than the liste of element who correspond of the function are selected.

During my research, I found that I need to use a trigger, but I have no idea how I can join these 2 conditions together.

Regards

Marcel

Re: Trigger with 2 conditions on date

giacomom — Wed, 26 Nov 2014 15:24:22 GMT

Hi Marcel,

you can put in OR the conditions with the '|' pipe sign, writing

='(>=2014-11-26 | 1940-01-01)'

in the Search String expression when you create the Select in Field action of the OnInput Trigger for your input box variable.

I hope this helps!

Giacomo

Re: Trigger with 2 conditions on date

Wed, 26 Nov 2014 15:52:36 GMT

Great thanks!

It was exactly my problem!

Marcel

Re: Trigger with 2 conditions on date

giacomom — Wed, 26 Nov 2014 16:12:18 GMT

I'm glad I could help

Please, if you solved the problem, mark the discussion as Answered.

Thank you,

Giacomo