Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

help to convert if-statement into set analysis

Hello

this should be fairly easy for an experienced user, but has caused me some issues today.

I have the following if-statement ( returns the correct value):

=count (if ( right (SourceCode_Auto,4) = '7932' or right (SourceCode_Auto, 4) = '7966', [Interest_IdCount]))

i.e. I have 2 conditions and one has to be fulfilled for the count to kick in. The SourceCode field is of the format xxxNNNNN, minimum 4 digits/letters and maximum8.The condition needs to be on the 4 last ones.

now, I tried this set analysis ( returns a too low value

=count ( { $ < [SourceCode_Auto]  = {'*7932', '*7966'} > [Interest_IdCount] }

Why doesn't that work out, and how should it be written?

many thanks to the person that might take pity on a beginner and explain this mystery.

12 Replies
maxgro
MVP
MVP

here for more on set analysis

Sets Analysis: syntaxes, exemples

Not applicable
Author

and it does! thank you so much!

Not applicable
Author

merci beaucoup!