Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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!!