topic Re: How to create this complex table... help please! in QlikView

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

Wed, 25 Nov 2020 16:16:04 GMT

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.

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

swuehl — Wed, 31 Aug 2016 19:21:30 GMT

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

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

Thu, 01 Sep 2016 17:45:34 GMT

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.

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

swuehl — Thu, 01 Sep 2016 18:49:16 GMT

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.