Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
Showing results for 
Search instead for 
Did you mean: 

Crosstable does not help

Hi Folks,

i have a question

my table does look like

                          Team A       Team B    Team C

Project 1          ok                    ok            bad

Project 2          ok                   bad           ok

Project 3          ok                   bad          bad

i want to achieve the result, where i have the following look:

project 1: Team A, Team B = ok   |  2

project 2: Team A, Team C = ok   | 2

project 3: Team A  |  1

project 1: Team C = bad   | 1

project 2: Team B = bad  | 1

project 3: Team B, Team C = bad | 2

my expected outpus is: on the base of value 1 and 2 i want to create the dimension: 1 = 1 Kombinataion, 2 = 2 Kombination.

Does anyboday have any idea how to resolve this issue


Thanks a lot




Labels (1)
3 Replies
MVP & Luminary
MVP & Luminary



Find the Qlikview app attached.

Hope this is what you want.



Kaushik Solanki

If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

Hi Kaushik,


Thanks a lot for your help. it does look good, but my expected output is:


Kombination , Team, Projects

1,  Team A, project 3

1 Team B, project 2

1 Team C, project 1

2 Team A, Team B, project 1

2 Team A. Team C, project 2

2 Team B, Team C, project 3


Do you have any idea how to solve this issue?


Thanks a lot

Contributor II
Contributor II

You can convert the app using dev-hub of qlik sense and can check the script in qlik sense once the application is converted.
Hope this might help