topic Re: Comapre two tables in QlikView

Comapre two tables

segerchr — Tue, 15 Mar 2016 08:36:30 GMT

Hi@all,

i am searching for a peace of code which compares two tables and shows the average of the trainigsvisits.

Tabel1 (Players):

PlayerID Name Name2 Foot Age

ID_001 Tom Smith Right 24

ID_002 Sarah Coy Left 31

***

Table2 (Games):

PlayerID GameID Time Lesson

ID_001 Game_01 2016-12-01 1

ID_002 Game_01 2016-12-01 1

ID_001 Game_02 2016-12-08 2

How can i compare if every player visited the each gameIDs.

So i will display for Game_01 / 100% for Game_02 / 50 % and so on.

Thanks

Re: Comapre two tables

sunny_talwar — Tue, 15 Mar 2016 09:04:33 GMT

May be this:

GameID as dimension

and expression -> =Count(PlayerID)/Count(TOTAL DISTINCT PlayerID)

Re: Comapre two tables

segerchr — Tue, 15 Mar 2016 13:23:49 GMT

Hey thanks for your answer. Is it also possible to show the avg of all trainingsvisits in a cake diagramm ?

Thank for helping.

Re: Comapre two tables

sunny_talwar — Tue, 15 Mar 2016 13:54:09 GMT

Cake diagram? Do you mean a pie chart or is this another diagram?

Re: Comapre two tables

segerchr — Tue, 15 Mar 2016 16:24:03 GMT

I mean a pie

Re: Comapre two tables

sunny_talwar — Tue, 15 Mar 2016 16:47:19 GMT

Like this?

Re: Comapre two tables

segerchr — Wed, 16 Mar 2016 13:30:50 GMT

Hi,

thanks for your answer again. The measure should be the avg(of the Game01 % and the Game02 %). In this case 75%.

The pie should only display 75%.

Thanks for helping.

Re: Comapre two tables

sunny_talwar — Wed, 16 Mar 2016 20:19:23 GMT

What about the other 25%? It just won't be visible?

Re: Comapre two tables

segerchr — Thu, 17 Mar 2016 08:04:21 GMT

It should also be visible in another color. The same diagram like above, only with the avg of the trainings percents.

Thanks a lot

Re: Comapre two tables

sunny_talwar — Thu, 17 Mar 2016 14:35:58 GMT

Like this?