Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Item property in several column

Hello,

Can help me. I have 2 table:

1-Item (field Item No_),

Item No_
A1
A2
A3
A4

2-Item Property (Item No_,Property No_).

Item No_Property No_
A1P1
A2P2
A3P3
A4P4
A2P2
A2P4
A3P1
A3P4
A4P3

Fields look like in qlikview I want to see this:

Item No_Property No_1Property No_2Property No_3Property No_4
A1P1P2P3P4
A2P2P4--
A3P1P3--
A4P3---


Its like hierarchy , but not exactly

1 Reply
jagan
Not applicable

Item property in several column

Hi,

Try using CROSS TABLE option in script.

Hope this helps you.

Regards,

Jagan.