topic Re: show total not depending on selection in QlikView

show total not depending on selection

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: show total not depending on selection

sunny_talwar — Wed, 30 Mar 2016 11:25:32 GMT

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?

Re: show total not depending on selection

Anonymous — Wed, 30 Mar 2016 11:46:02 GMT

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

Re: show total not depending on selection

sunny_talwar — Wed, 30 Mar 2016 12:29:59 GMT

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])))

Re: show total not depending on selection

Anonymous — Wed, 30 Mar 2016 12:59:22 GMT

Thank You Sunny!!!

Antonio