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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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