Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
silvia_assuncao
Creator
Creator

Total Sum only if one item selected

Hi Everyone,

I have this tab, and I want it to show the total sum only if I select one user (resource). is it possible?

thanks

3 Replies
m_woolf
Master II
Master II

You can put:  GetSelectedCount(Resource)=1 in the Conditional show of your chart. Then add a Resource listbox.

sunny_talwar

Check out this expression

If(GetSelectedCount(Resource) <> 1, If(Dimensionality() > 0, Sum([% Resource])), Sum([% Resource]))

silvia_assuncao
Creator
Creator
Author

great!

thanks