Help loading in data and applying the correct value to its section

hopkinsc — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am trying to load in some excel data and apply the correct section value to the section name.

The data looks like the following..

Section	201901	201902
Item
Manufacturing PV	11,210	10,310
Freight PV	110	91
Duty PV	2,810	910
Export Sales	(8)	(3,398)
Retail Sales	(23,012)	(21,102)
Trade Sales	(23,080)	(2,210)
Sales Admin	(930)	(3,180)
Marketing	(2,110)	(22,192)
QC	(11,093)	(12,918)



Distribution
Salaries	(3,031)	(8,039)
Travel	--	--
Sundry	(28)	(22)

The 'Section' field contains a combination of 'section names' and 'section values', so Item is a name and the values that i need to appear against it would be 'Manufacturing PV', 'Freight PV' etc, then Distribution is a name and the values would be 'Salaries', 'Travel' etc.

The names are determined by looking at the first column after it and checking if there is a value, if there is not (its blank) then the value in the Section field is a section name.

I have done this logic and extracted all of the Section Names into it's own field, but i also need to ensure that the Section Values are linked to the name, this is what i am struggling to do.

I have attached a sample, could anyone help please?

Re: Help loading in data and applying the correct value to its section

sunny_talwar — Thu, 06 Jun 2019 13:05:59 GMT

How do you like this?

Re: Help loading in data and applying the correct value to its section

hopkinsc — Thu, 06 Jun 2019 14:53:51 GMT

Excellent 🙂 Thanks again.

topic Re: Help loading in data and applying the correct value to its section in QlikView

Help loading in data and applying the correct value to its section

Re: Help loading in data and applying the correct value to its section

Re: Help loading in data and applying the correct value to its section