Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jcfrasco
Creator
Creator

Specific Table Format

Hi

I'm wondering whether you can format a table in a very specific way. I have two dimensions of interest, and I would like to display the second dimension grouped in sections based on the first dimension. The format however, is that the first dimension is used as a separator in the same column as the second dimension, and not as a separate column which is what Qlikview will do by default.

So a table that looks like this (or the equivalent thereof for a pivot table) is what I have.

Dimension 1Dimension 2Expression 1Expression 2
Section 1A112
Section 1B211
Section 1C310
Section 2D49
Section 2E58
Section 2F67

I want it to look like this:

Dimension 2Expression 1Expression 2
Section 1
A112
B211
C310
Section 2
D49
E58
F67

Is there any way to do this.

Thanks.

Joao.

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

2 Replies
anbu1984
Master III
Master III

jcfrasco
Creator
Creator
Author

Genius!

Thank you so much.

Joao