topic on open trigger in QlikView

on open trigger

kunkumnaveen — Thu, 11 Aug 2016 12:28:08 GMT

Hello All

How to get select multiple dates on opening the application

i got a Date field data like this

Date

03 Jan

04 Jan

30 Jan......

i wrote two Triggers(on open)

1)select in field ----->Date

23 Jan

2) Select in field ---->Date

='<=$(=Date(Date,'DD MMM YYYY'))' which is not working

o/p i am looking is on open the document

i need this 03 Jan <= 23 Jan

thanks

naveen

Re: on open trigger

avinashelite — Thu, 11 Aug 2016 12:31:28 GMT

Naveen, one easy way is to set a flag in the script for the values where you need to select the dates and then set a on open trigger to select the value 1 i.e. the flag field which will be a easy way to handle

Re: on open trigger

settu_periasamy — Tue, 16 Aug 2016 18:55:25 GMT

You can assign the value into the variable and you can use that in your trigger. for e.g

Variable Name : vMin

Value : =Date(Date#('03 Jan 2016','DD MMM YYYY'),'DD MMM YYYY')

Variable Name : vMax

Value : =Date(Date#('23 Jan 2016','DD MMM YYYY'),'DD MMM YYYY') // You can change this as dynamic instead of hard code date

In your trigger, you can try like

search string would be , ='>='&vMin&'<='&vMax