Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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

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

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

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

 

Community Browser