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: 
bc-thebruuu
Creator
Creator

Set analysis : Elements list vs Search strings

Hello

I thought to be pretty good at Set Analysis but recently I bumped in a weird case:

I need to analyse the temporal evolution of some data and ended up to use search strings in my set analysis.

Using this solution,

I have been faced with weird result that I have been able to reproduce in a simple use case:


Let's load those data:


LOAD * INLINE [

    KEY, VALUE

    A, 1

    A, 2

    B, 1

    C, 2

    C, 1

     D,1

     D,3

];

count({<VALUE={'1'}>}KEY) is equal to 4  ... not surprinsingly

BUT

count({<KEY={"=(VALUE=1)"}>}KEY)   IS = 1  ????? It seems to count only Those Key whose only value is 1!?

Why?

And How can I get 4 using a search string?

10 Replies
bc-thebruuu
Creator
Creator
Author

Thank you very much