Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!