topic Re: how to add extra values to the dimension field? in QlikView

how to add extra values to the dimension field?

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

Hi,

I have a job field it consist some values, i want to add some more values to job field how can i add .

Thanks

Anji

qlikview979 — Mon, 22 May 2017 09:41:35 GMT

Hi,

As per my knowledge create Inline table with values and add it to the main table

qlikview979 — Mon, 22 May 2017 09:45:33 GMT

like this

T1:

LOAD Product, ////product having P1,P2,P3

Sales

FROM

(ooxml, embedded labels, table is Sheet2);

Concatenate(T1)

T2:

LOAD * Inline [

Product

];

Result:-

Product,Sales

P1,100

P2,200

P3,300

P4,-

P5,-

P6,-

P7-

Akina0929 — Mon, 22 May 2017 09:53:19 GMT

Thank you mahesh

qlikview979 — Mon, 22 May 2017 09:56:04 GMT

Hi Anji,

if you receive the correct answer,please mark it as correct answer,may be in future this is help full for others.

Regards

qlikview979 — Mon, 22 May 2017 09:56:29 GMT

Good

lwileczek — Thu, 25 Oct 2018 16:47:35 GMT

Is there away to assign values to the added dimensions? e.g.
P4 is the sum of P1-P3
P5 is the mean of P1-P3