Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Equation Issue!!

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

1 Solution

Accepted Solutions
MarcoWedel

plese post sample app/data to test your expression with

regards

Marco

View solution in original post

3 Replies
MarcoWedel

plese post sample app/data to test your expression with

regards

Marco

Not applicable
Author

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

MarcoWedel

Hi Peter,

glad you got it.

Good night

Marco