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