topic Action - Select in field with variable in QlikView

Action - Select in field with variable

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am trying to make an action based on input field of an variable and select in Field the values [Data Sales ]that are greater than vStartMonth.

The versions: '>=$(vStartMonth)', '>=vStartMonth' are not working. If i put '>=4/1/2014' it works. My variable vStartMonth is 4/1/2014.

Any suggestion regarding the format?

Thank you,

Cosmina

Re: Action - Select in field with variable

sunny_talwar — Mon, 23 Jan 2017 12:32:51 GMT

May be formatting is different or you need to have it read as date? Can you share what is the definition of vStartMonth? Is it hardcoded or an expression?

Re: Action - Select in field with variable

Anonymous — Mon, 23 Jan 2017 12:50:13 GMT

Hi,

I have attached a sample at what i want to do. In the Action button, i don't know which is the syntax for filtring data with variable.

Thank you,

Re: Action - Select in field with variable

sunny_talwar — Mon, 23 Jan 2017 12:54:16 GMT

This seems to working

='>=' & vStartDate

Re: Action - Select in field with variable

Anonymous — Mon, 23 Jan 2017 13:04:19 GMT

Thank you