Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
saivina2920
Creator
Creator

Getting error while passing variables in count expression

I am getting error while pass variables in count expression.

=count(DISTINCT if((Date(DueDate,'dd-mm-yyyy') - Today() > -5 and Date(DueDate,'dd-mm-yyyy') - Today() < 0) and (CURRENTSTATUS='NEW' and FROM='*BRITTA*' and TO={"$(vManufacturer)"}),DueDate))

Error comes in TO={"$(vManufacturer)"}

What is the problem in the above condition..?

Labels (1)
2 Replies
edwin
Specialist III
Specialist III

try using single quotes assuming the variable returns TEXT

TO={'$(vManuf)'}

edwin
Specialist III
Specialist III

hold on, is that your actual expression?  or the TO={..} in a set analysis?

if in set analysis, try what i suggested but if this is actually a condition in your IF statement, use TO = '$(vManufacturer)'