Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jiwabhsmp
Contributor II
Contributor II

How do you show crosstable percentages of total per column?

Hi,

I have a table of candidates who have completed multiple tests. Each candidate has a score per test (if they have completed the test).

The highest score for any of the tests is 9.

Please see the below table for the data set.

  

CandidateTest1Test2Test3
Emp1367
Emp2369
Emp3578
Emp4269
Emp5168
Emp625
Emp7149
Emp82
Emp93
Emp1041

How would I be able to show for each test, what the total per score would be as a percentage? For example for Test1, 20% got a score of 1.

I have used the Qlikview Pivot table for this as a count and then sum of total Test1 to bring back the percentage, however, this creates multiple tables. Would it be possible to do this in one table? Please see below and the values would be percentages per score.

 

ScoreTest1Test2Test3
1
2
3
4
5
6
7
8
9
10

Kind regards,

Suraj

1 Solution

Accepted Solutions
ahaahaaha
Partner
Partner

Hi Suraj,

If I understood you correctly (look attached file)

Table1:

LOAD*,

RecNo() as Score;

LOAD Candidate,

    Test1,

    Test2,

    Test3

FROM

[https://community.qlik.com/thread/267198?sr=inbox&ru=241931]

(html, codepage is 1251, embedded labels, table is @1);

Left Join

LOAD

Test1 as Score,

Count(Test1) as Test_1

Resident Table1

Group By Test1;

Left Join

LOAD

Test2 as Score,

Count(Test2) as Test_2

Resident Table1

Group By Test2;

Left Join

LOAD

Test3 as Score,

Count(Test3) as Test_3

Resident Table1

Group By Test3;

Drop Fields Candidate, Test1, Test2, Test3;



Result

1.jpg

Regards,

Andrey

View solution in original post

3 Replies
sunny_talwar

Would you be able to share a sample where you have tried this?

ahaahaaha
Partner
Partner

Hi Suraj,

If I understood you correctly (look attached file)

Table1:

LOAD*,

RecNo() as Score;

LOAD Candidate,

    Test1,

    Test2,

    Test3

FROM

[https://community.qlik.com/thread/267198?sr=inbox&ru=241931]

(html, codepage is 1251, embedded labels, table is @1);

Left Join

LOAD

Test1 as Score,

Count(Test1) as Test_1

Resident Table1

Group By Test1;

Left Join

LOAD

Test2 as Score,

Count(Test2) as Test_2

Resident Table1

Group By Test2;

Left Join

LOAD

Test3 as Score,

Count(Test3) as Test_3

Resident Table1

Group By Test3;

Drop Fields Candidate, Test1, Test2, Test3;



Result

1.jpg

Regards,

Andrey

View solution in original post

jiwabhsmp
Contributor II
Contributor II
Author

Hi Andrey,

Brilliant, thank you!

Kind regards,