Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with Variable

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?

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

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


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

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

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


talk is cheap, supply exceeds demand
Not applicable
Author

thanks., it works