Crosstable does not help

[beck_bakytbek]

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

Beck

[kaushiknsolanki]

Hi,

Find the Qlikview app attached.

Hope this is what you want.

Regards,

Kaushik Solanki

[beck_bakytbek]

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

[bharatchauhan]

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