Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.