topic Creating dimension from data on a single row in QlikView

Creating dimension from data on a single row

nsm1234567 — Tue, 03 Feb 2015 14:12:40 GMT

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:

ID	Positive Theme 1	Positive Theme 2	Negative Theme 1
1	Positive Service
2		Positive Brand	Negative Service

Targeted Table:

ID	Theme
1	Service
2	Service
2	Brand

Re: Creating dimension from data on a single row

avinashelite — Tue, 03 Feb 2015 14:25:16 GMT

Hi Nathan,

Please find the attachment for the solution:

Re: Creating dimension from data on a single row

avinashelite — Tue, 03 Feb 2015 14:27:45 GMT

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

Re: Creating dimension from data on a single row

nsm1234567 — Thu, 05 Feb 2015 12:31:45 GMT

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