topic Re: Which table can I use for Complex reports in QlikView? in QlikView

Which table can I use for Complex reports in QlikView?

hamy_IT_Dev — Tue, 01 Jan 2019 12:29:08 GMT

I have to create a report like this:

what is your suggestion?

Re: Which table can I use for Complex reports in QlikView?

Gysbert_Wassenaar — Tue, 01 Jan 2019 13:10:52 GMT

Looks like a pivot table to me.

Re: Which table can I use for Complex reports in QlikView?

Anil_Babu_Samineni — Tue, 01 Jan 2019 13:11:11 GMT

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

Re: Which table can I use for Complex reports in QlikView?

hamy_IT_Dev — Sat, 05 Jan 2019 19:55:01 GMT

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

Re: Which table can I use for Complex reports in QlikView?

Gysbert_Wassenaar — Sun, 06 Jan 2019 06:45:16 GMT

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... )

Re: Which table can I use for Complex reports in QlikView?

hamy_IT_Dev — Sun, 06 Jan 2019 08:49:15 GMT

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