Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Group of fields with a title label

Hi,

I want to know if it's possible to do this in qlikview and how can I do it.

This is my example:

Title LabelTitle LabelTitle LabelTitle Label
FieldFieldFieldFieldFieldFieldFieldFieldFieldFieldFieldField

Can I do a group like this in qlikview?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

This should be possible using a pivot table.

You'll need to link your Title Lables to the fields:

LOAD * INLINE [

title, field, value

A, f1, 1

A, f2, 2

A, f3, 3

B, f4, 4

B, f5,5

];

Then create a pivot table with dimensions title and field and as expression e.g. only(value).

Drag the two dimensions to the top.

Hope this helps,

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

This should be possible using a pivot table.

You'll need to link your Title Lables to the fields:

LOAD * INLINE [

title, field, value

A, f1, 1

A, f2, 2

A, f3, 3

B, f4, 4

B, f5,5

];

Then create a pivot table with dimensions title and field and as expression e.g. only(value).

Drag the two dimensions to the top.

Hope this helps,

Stefan

Not applicable
Author

Thank you so much!!