topic Crosstable does not help in QlikView

Crosstable does not help

beck_bakytbek — Sat, 16 Nov 2024 21:50:11 GMT

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 — Sat, 24 Nov 2018 06:27:49 GMT

Hi,

Find the Qlikview app attached.

Hope this is what you want.

Regards,

Kaushik Solanki

beck_bakytbek — Sat, 24 Nov 2018 08:15:05 GMT

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 — Sat, 24 Nov 2018 08:16:07 GMT

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