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.

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

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

Beck

 

 

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

Hi,

 

Find the Qlikview app attached.

Hope this is what you want.

 

Regards,

Kaushik Solanki

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

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