Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

segerchr
New Contributor II

Comapre two tables

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

CS

9 Replies

Re: Comapre two tables

May be this:

GameID as dimension

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


Capture.PNG

segerchr
New Contributor II

Re: Comapre two tables

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

Thank for helping.

BR

CS

Re: Comapre two tables

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

segerchr
New Contributor II

Re: Comapre two tables

I mean a pie 

Re: Comapre two tables

Like this?

Capture.PNG

segerchr
New Contributor II

Re: Comapre two tables

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

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

segerchr
New Contributor II

Re: Comapre two tables

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

Like this?

Capture.PNG

Community Browser