Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

hamy_IT_Dev
New Contributor II

Which table can I use for Complex reports in QlikView?

Hi

I have to create a report like this:Capture.PNG

 what is your suggestion?

 

2 Solutions

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

Looks like a pivot table to me.


talk is cheap, supply exceeds demand
Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
5 Replies
MVP & Luminary
MVP & Luminary

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

Looks like a pivot table to me.


talk is cheap, supply exceeds demand

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

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

Life is so rich, and we need to respect to the life !!!
hamy_IT_Dev
New Contributor II

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

Hi  

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

Highlighted
MVP & Luminary
MVP & Luminary

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

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


talk is cheap, supply exceeds demand
hamy_IT_Dev
New Contributor II

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

 Thanks , 

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