Date index in variable

Wed, 03 Apr 2013 13:57:30 GMT

Hi all,

I am trying to get a date index nunber into a variable but unsure how..

Basically i have a field [Reporting Week Index] and i am trying to store the current value for this field in a variable.

I want it to be dynamic, so when a date in the field [Reporting Date] is selected, this will then change the variable with the [Reporting Week Index] for the date selected.

Can anyone help?

Re: Date index in variable

Gysbert_Wassenaar — Wed, 03 Apr 2013 14:11:30 GMT

Add a Set Variable action to the On Select trigger of [Reporting Date] to set your variable to max([Reporting Week Index]). There should be only one max [Reporting Week Index] for the Reporting Date so you'll get the right Week Index number in the variable.

topic Date index in variable in QlikView

Date index in variable

Re: Date index in variable