topic Getting error while passing variables in count expression in QlikView

Getting error while passing variables in count expression

saivina2920 — Fri, 15 Nov 2024 23:29:13 GMT

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..?

Re: Getting error while passing variables in count expression

edwin — Tue, 08 Dec 2020 19:47:45 GMT

try using single quotes assuming the variable returns TEXT

TO={'$(vManuf)'}

Re: Getting error while passing variables in count expression

edwin — Tue, 08 Dec 2020 19:50:08 GMT

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)'