topic Equation Issue!! in QlikView

Equation Issue!!

Tue, 01 Sep 2015 21:46:30 GMT

Hi Community

Can anyone see anything wrong with this expression?

=if(vcomp='function' and count(if(Function='Direct Marketing',Function and S1IndOrg='Ind', S1IndOrg))<5 and vchart=3,1,0)

Trying to use this to in a show condition, if the count of direct marketing and the count of S1IndOrg is less than 5, and if vchart is 3 and if vcomp = function, the object should delete off, it doesn't though!

Any ideas? have pondered using set analysis, though don't see why this wont work.

The underlined part above = 2, and the other parameters are true!

Any ideas would be greatly appreciated

Thanks

Peter

Re: Equation Issue!!

MarcoWedel — Tue, 01 Sep 2015 21:57:38 GMT

plese post sample app/data to test your expression with

regards

Marco

Re: Equation Issue!!

Tue, 01 Sep 2015 22:01:06 GMT

Marco, thanks for the response

Got it sorted, capital grammar mistake on 1 of the variables, sorry!

Its 11 O'clock here in Belfast, been looking at this screen for way to long

Thanks

Peter

Re: Equation Issue!!

MarcoWedel — Tue, 01 Sep 2015 22:04:20 GMT

Hi Peter,

glad you got it.

Good night

Marco