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: 
chibi
Creator
Creator

Where clause in set analysis

Hi i'm trying to do this. 

 

sum(game_session_count) where count(distinct sales_session_game_link_id)

 

Anyone know whats the correct formula? 

4 Replies
anat
Master
Master

=sum({<game_session_count = {"=count`(distinct sales_session_game_link_id) >1"}>} distinct game_session_count)

 

chibi
Creator
Creator
Author

So do I create a variable for the count measure and put it inside the sum? How does it work I understand the link given but it does not help show how two measures sum and count can be in one expression 

chibi
Creator
Creator
Author

It returned a value of zero. {"=count`(distinct sales_session_game_link_id) >1"}>}  what does this part mean >1?

also why is there a distinct game_session_count? 

 

chibi_0-1641452758990.png