show total not depending on selection

[Anonymous]

Good morning,

I have being trying now for quite a bit to solve my problem but could not find a solution. I tried with set analysis, aggr, total and looked at Qlik help, youtube videos and qlik community posts.

I enclose a sample file.

On last column I would like to show the cashed platform's total once I select one or more games but of course not all of them.

I will appreciate your help with this matter.

Thanks

Antonio

[sunny_talwar]

Not sure what you are looking for? You just don't want the total to change or do you want the rows to stay intact also based on selection in game name? Also there are 4 charts in your sample, which chart are we looking at?

[Anonymous]

Hi Sunny,

In the picture I am showing what I would like to see when I select some games. I wish to have in the last column the total of the platform that does not have to change when I select the games. The two table are the same: one straight and the other pivot.

Thanks

Antonio

[sunny_talwar · Accepted solution]

Check the attached:

Expression:

=If(GetSelectedCount([game name]) = 0, Sum([money cashed by single game]),

If(Sum([money cashed by single game]) > 0,Sum(TOTAL <[platform name]> {<[game name]>}[money cashed by single game])))

[Anonymous]

Thank You Sunny!!!

Antonio