topic Re: Set Analysis with Variable in QlikView

Set Analysis with Variable

Tue, 31 Dec 2013 14:00:53 GMT

Hi,

i have a variable as varFromDate where i put year = 2013

in below, it's not working with variable .

=Count({$ +<%Year={"<=[varFromDate]"}, TYPE={'T'} >} DISTINCT EmpCode)

if i use below it's working.

=Count({$ +<%Year={"<=2013"}, TYPE={'T'} >} DISTINCT EmpCode)

any idea why it's working with variable?

Gysbert_Wassenaar — Tue, 31 Dec 2013 14:09:16 GMT

If varFromDate is indeed a variable and not a field name try it like this:

=Count({$ +<%Year={"<=$(varFromDate)"}, TYPE={'T'} >} DISTINCT EmpCode)

Tue, 31 Dec 2013 14:32:35 GMT

thanks., it works