Hello,
I need to create a cross table in Qlik sense, Current table structure is below, and wanted an output as below. Is it possible?
It shoud give me count of if where KNI is incomplete,ciritical is true,Outsourcing is Yes and Group is Yes.
How do I do that in pivot table so that I can get same format.
Also want to group KNI in 2 pack link below.
My table right now
|
ID
|
KNI_1
|
KNI_2
|
KNI_3
|
Critical
|
Outsourcing
|
Group
|
Countries
|
|
136936280
|
Incomplete
|
complete
|
Incomplete
|
TRUE
|
YES
|
Yes
|
India
|
|
110192957
|
Incomplete
|
complete
|
Incomplete
|
TRUE
|
YES
|
Yes
|
India
|
|
123711230
|
Incomplete
|
complete
|
Incomplete
|
FALSE
|
No
|
Yes
|
India
|
|
192122047
|
Incomplete
|
complete
|
Incomplete
|
FALSE
|
No
|
Yes
|
India
|
|
61976243
|
Incomplete
|
complete
|
complete
|
FALSE
|
No
|
Yes
|
US
|
|
114298790
|
Incomplete
|
complete
|
complete
|
FALSE
|
No
|
No
|
US
|
|
177766174
|
complete
|
complete
|
complete
|
TRUE
|
No
|
No
|
US
|
|
90938388
|
complete
|
complete
|
complete
|
FALSE
|
No
|
No
|
US
|
|
182210776
|
complete
|
complete
|
complete
|
TRUE
|
No
|
No
|
UK
|
|
104968900
|
complete
|
complete
|
complete
|
TRUE
|
Yes
|
No
|
UK
|
|
113302616
|
complete
|
complete
|
complete
|
TRUE
|
Yes
|
No
|
UK
|
Result should be
|
PACK1
|
KNI_1(Incomplete)
|
|
India
|
US
|
UK
|
|
|
|
Critical=TRUE
|
2
|
1
|
0
|
|
|
|
Outsourcing=Yes
|
4
|
1
|
4
|
|
|
|
Group=Yes
|
8
|
5
|
5
|
|
|
KNI_2
|
Critical=TRUE
|
9
|
2
|
5
|
|
|
|
Outsourcing=Yes
|
3
|
9
|
7
|
|
|
|
Group=Yes
|
9
|
7
|
10
|
|
PACK2
|
KNI_3
|
Critical=TRUE
|
6
|
10
|
5
|
|
|
|
Outsourcing=Yes
|
10
|
1
|
1
|
|
|
|
Group=Yes
|
2
|
6
|
10
|
