Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 Label | Title Label | Title Label | Title Label | ||||||||
Field | Field | Field | Field | Field | Field | Field | Field | Field | Field | Field | Field |
Can I do a group like this in qlikview?
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
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
Thank you so much!!