Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Qlikview - Variable that assume multiple values

Hi experts,

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

A

B

C

D

E

ID

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:

FieldNOTE1NOTE2
A
B
C
D
E

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

 

FieldBCDENOTE1NOTE2
A
B
C
D
E

Many thanks!

2 Replies

Re: Qlikview - Variable that assume multiple values

May be like this:

Table:

CrossTable(Field, Value)

LOAD ID,

           A,

           B,

           C,

           D,

           E

FROM...

Left Join (Table)

LOAD ID,

           Note1,

           Note2

FROM ...

Or
Valued Contributor II

Re: Qlikview - Variable that assume multiple values

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?