Create straight table with repeating values

[binitsingh]

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

[chrismarlow]

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.

[binitsingh]

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

[chrismarlow]

Hi,

I am not entirely sure this is what you need, but it looks the same as your output;

Cheers,

Chris.

[binitsingh]

Hi Chris,

Thank you.

[binitsingh]

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

[binitsingh]

Hi Team,

Help me.