Which table can I use for Complex reports in QlikView?

[hamy_IT_Dev]

Hi

I have to create a report like this:

 what is your suggestion?

[Gysbert_Wassenaar · Accepted solution]

Looks like a pivot table to me.

[Anil_Babu_Samineni]

I would prefer to use Set analysis based on Filter in reports. What you are asking is not the correct question. Can you please ask in detail

[hamy_IT_Dev]

Hi  Gysbert_Wassenaar

Thanks, this helped

I used pivot table

But

How can I add 'All' Column

All = (All column in Group1 + All column in Group2 + All column in Group3) / 3

[Gysbert_Wassenaar · Accepted solution]

Enable the Partial Sums option for the relevant dimensions on the Presentation tab of the properties window of the pivot table.

If you need to use a different expression for the Total column then you'll have to use the SecondaryDimensionality() function. If(SecondaryDimensionality() >0, ...expression for total column... , ...expression for detail columns... )

[hamy_IT_Dev]

 Thanks , Gysbert_Wassenaar

I did it by changing my column expressions like this:

avg(aggr(column expression,dimension1,dimension2))

avg(aggr(column expression,Province,Group))

But

When I do this solution, I see avg of All and avg of city and avg of All

but I have to show just Avg of All Column