Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jmarinesc
New 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

Re: Error in expression Count takes 1 parameter...

HI

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

And did u use group by too??

Hope it helps

2 Replies

Re: Error in expression Count takes 1 parameter...

HI

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

And did u use group by too??

Hope it helps

jmarinesc
New Contributor III

Re: Error in expression Count takes 1 parameter...

Tk! 

It works.. yepppppp!

Community Browser