Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
anjaneyulu
Contributor

how to add extra values to the dimension field?

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

1 Solution

Accepted Solutions
qlikview979
Valued Contributor

Re: how to add extra values to the dimension field?

Hi,

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

View solution in original post

6 Replies
qlikview979
Valued Contributor

Re: how to add extra values to the dimension field?

Hi,

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

View solution in original post

Highlighted
qlikview979
Valued Contributor

Re: how to add extra values to the dimension field?

like this

T1:

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

     Sales

FROM

(ooxml, embedded labels, table is Sheet2);

Concatenate(T1)

T2:

LOAD * Inline [

Product

P4

P5

P6

P7

];

Result:-

Product,Sales

P1,100

P2,200

P3,300

P4,-

P5,-

P6,-

P7-

anjaneyulu
Contributor

Re: how to add extra values to the dimension field?

Thank you mahesh

qlikview979
Valued Contributor

Re: how to add extra values to the dimension field?

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
Valued Contributor

Re: how to add extra values to the dimension field?

Good

lwileczek
New Contributor III

Re: how to add extra values to the dimension field?

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