Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

nsm1234567
Contributor

Creating dimension from data on a single row

Hi There,

I'm hoping someone might be able to assist with some trouble I'm having sorting out some oddly formatted data.  Below I've approximated what my data looks like (except that there are many more themes).  What I want ultimately is a new dimension called "Theme" which would consist of "Service" and "Brand" in the below case.  There would then be two instances of the "Service" theme (one negative and one positive) and another instance of the brand theme.  I've pasted my envisaged table under "Targeted" below.  Does anyone know how I might be able to accomplish that?   Any help would be greatly appreciated.

Current:

IDPositive Theme 1Positive Theme 2Negative Theme 1Negative Theme 2
1Positive Service
2Positive BrandNegative Service

Targeted Table:

IDTheme
1Service
2Service
2Brand
1 Solution

Accepted Solutions

Re: Creating dimension from data on a single row

Hi  Nathan,

Please find the attachment for the solution:

View solution in original post

3 Replies

Re: Creating dimension from data on a single row

Hi  Nathan,

Please find the attachment for the solution:

View solution in original post

Re: Creating dimension from data on a single row

I have designed the above solution based on your question inputs , actually what is the exact requirement??

so that we can guide you on the proper path to achieve your requirement

nsm1234567
Contributor

Re: Creating dimension from data on a single row

Hey There, that is perfect for my needs.  Thanks so much