topic Re: Qlikview - Variable that assume multiple values in QlikView

Qlikview - Variable that assume multiple values

Mon, 12 Sep 2016 12:25:01 GMT

Hi experts,

Imagine that I've five (six with the ID) different fields on a Table:

And I've another table that have a field that classifies this fields:
ID
NOTE1
NOTE2

Basically my fact tableis:
ID
A
B
C
D
E
NOTE1
NOTE2

How can I build a table like this:

Field	NOTE1	NOTE2
A
B
C
D
E

When I insert the multiple fields into Dimensions I'm getting like this

Field	B	C	D	E	NOTE1	NOTE2
A
B
C
D
E

Many thanks!

Re: Qlikview - Variable that assume multiple values

sunny_talwar — Mon, 12 Sep 2016 12:31:38 GMT

May be like this:

Table:

CrossTable(Field, Value)

LOAD ID,

FROM...

Left Join (Table)

LOAD ID,

Note1,

Note2

FROM ...

Re: Qlikview - Variable that assume multiple values

Or — Mon, 12 Sep 2016 12:46:11 GMT

From your description, it isn't clear what the relation is, if any, between a specific value of A to a specific value of Note1 and Note2. How is your QlikView table supposed to tell which of the five columns (A-E) is the one associated with a specific note?