Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

total count not depending on selection

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.

total count games in platform.jpg

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Maybe like

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

View solution in original post

5 Replies
swuehl
MVP
MVP

Maybe like

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

View solution in original post

sunny_talwar

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


Capture.PNG

Anonymous
Not applicable
Author

Thank you swuehl,

work fine

Antonio

Anonymous
Not applicable
Author

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

sunny_talwar

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