Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create this complex table... help please!

Hi All,

Would you please tell me on how to create a table as show in the picture in Qlikview? A pivot inside a straight table? A complex aggregated straight table? Pivot in another pivot table? I have no clue... please help!

Thank you for your help everyone.

3 Replies
swuehl
MVP
MVP

Maybe you can use calculated dimensions using advanced aggregation to achieve what you want, i.e. return aggregated values as dimension values:

Create a pivot table chart with first dimension TFN

Next four dimensions would be calculated dimensions, like

=Aggr( Sum(Volume), TFN)

for the second (total volume)

6th dimension would be your BU field to split your expression into BU per expression.

Then follow your expressions for Answered, Abandoned, etc.

AGGR...

Pitfalls of the Aggr function

Not applicable
Author

Hi Stefan,

Thank you for your reply, I think I got the TFN and its 4 dimentions.

Would you please give me more detail or an example on this "6th dimension would be your BU field to split your expression into BU per expression."

Thanks again.

swuehl
MVP
MVP

I assumed your model shows a field that you can use to group your TFN field values into different business units.

Basically, I assumed that BU is just another dimension field.