Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
jmarinesc
Contributor III
Contributor III

Error in expression Count takes 1 parameter...

Hello;

I have an error expression..but I don´t find it...pleae help me on this....tk in advanced. (Maybe is in bold Exp..)

Error in expression:
Count takes 1 parameter

LOAD
remision
,if(count(remision)=1 ,-1)as "NoMatch"
,if(count(remision)>=2,-2)as "SiMatch"
,if(maxstring(idestacion)<>minstring(idestacion),-4) as "DifEstacion"
,if(max(vnatural)<>min(vnatural),-5)as "DifLitros"

,if(maxstring(idproducto)= minstring(idproducto),-7)as "IgDesc"

,if(count(remision)>=2 and (maxstring(idproducto)=minstring(idproducto)),-1) as "NoMatch1"
,if(count(remision)>=2 and (count(distinct(idproducto)=1,-1))) as "NoMatch2"

Tk QCommunity!

1 Solution

Accepted Solutions
MayilVahanan

HI

if(count(remision)>=2 and (count(distinct idproducto))=1,-1) as "NoMatch2

And did u use group by too??

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
MayilVahanan

HI

if(count(remision)>=2 and (count(distinct idproducto))=1,-1) as "NoMatch2

And did u use group by too??

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
jmarinesc
Contributor III
Contributor III
Author

Tk! 

It works.. yepppppp!