topic Re: total count not depending on selection in QlikView

total count not depending on selection

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

Good morning,

I have being trying to solve my problem but could not find a solution. I tried with total, count and set analysis but still have the problem.

On last column I would like to show the total number of games in the platform to which the game belongs independently on the games selection.

See enclosed file and below image.

Yesterday I got help from SunnyT. on the "total cashed by platform" and thought I could use the same code adjusted for the "total number of games in platform" but I cannot have it working.

I will appreciate your help with this matter.

Thanks

Antonio

Re: total count not depending on selection

swuehl — Thu, 31 Mar 2016 10:30:07 GMT

Maybe like

=Count({<[game name]>}Total<Town,[platform name]> [game name])*Sum(1)

Re: total count not depending on selection

sunny_talwar — Thu, 31 Mar 2016 10:30:48 GMT

Try this:

=If(GetSelectedCount([game name]) = 0, Count([game name]),

if(GetSelectedCount([game name])>0, If(Count([game name]) > 0, Count({<[game name]>}TOTAL<Town, [platform name]>[game name]))))

Re: total count not depending on selection

Anonymous — Thu, 31 Mar 2016 10:37:31 GMT

Thank you swuehl,

work fine

Antonio

Re: total count not depending on selection

Anonymous — Thu, 31 Mar 2016 10:39:28 GMT

Hi Sunny,

works fine with selected games but on "reset" the number goes to 1 so I went for the above suggested although I would be happy to see a modified version of your code which works once you reset.

Antonio

Re: total count not depending on selection

sunny_talwar — Thu, 31 Mar 2016 11:20:25 GMT

Stefan's code is much better, but if you want, this should work as well

=If(Count([game name]) > 0, Count({<[game name]>}TOTAL<Town, [platform name]>[game name]))