Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am new in qliksense . I got one requirement from my client. I have to create the straight table using duplicates values.
Below are the example of expected output:-
High level | Low level | Business |
Risk value 1 | Type | 80-678/2022 |
Risk value 1 | Risk point | closed |
Risk value 1 | product | col |
Risk value 1 | intern | F1 |
Risk value 2 | Type | 5678/2023 |
Risk value 2 | Risk point | open |
Risk value 2 | intern | vol |
Risk value 2 | product | F2 |
I have to create a table as above .
Kindly help me to achieve the expected output.
Thanks in advance.
Binit Singh
Hi,
I think you have shown how you want your data to appear in the table, but is not clear what the data that you want to manipulate looks like in existing data table(s). Can you share that?
Cheers,
Chris.
Hi Chris,
Thanks for showing interest in my post.
Below are the example of data set based on that data I have to achieve resultant output:-
Data example:-
Data Set Table | |||
Issues ID | High level | Low level | Business |
12378 | Risk value | Type | 80-678/2022 |
12378 | Risk value | Risk point | closed |
12378 | Risk value | product | col |
12378 | Risk value | intern | F1 |
23456 | Risk value | Type | 5678/2023 |
23456 | Risk value | Risk point | open |
23456 | Risk value | intern | vol |
23456 | Risk value | product | F2 |
Output table | |||
Table 1 | |||
High level | Low level | Business | |
Risk value 1 | Type | 80-678/2022 | |
Risk value 1 | Risk point | closed | |
Risk value 1 | product | col | |
Risk value 1 | intern | F1 | |
Risk value 2 | Type | 5678/2023 | |
Risk value 2 | Risk point | open | |
Risk value 2 | intern | vol | |
Risk value 2 | product | F2 |
Hi,
I am not entirely sure this is what you need, but it looks the same as your output;
Cheers,
Chris.
Hi Chris,
Thank you.
Hi Team,
I got the requirements in my organization. I have raw data sample and Requirements sample in excel sheet in attachements.
Need your help to resolve the issues asap in qliksense.
Thanks and Regards,
Binit Singh
Hi Team,
Help me.