Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Req on Straight/Pivot table

Hi All,


I have 2 requirements on pivot/straight table

1) I have multiple dimensions and expressions and i want to display the totals at header level in the table as below:

Capture.PNG.png

2) I want to add one more expression there i will get data from DB based on some conditions. I want to display as below

Capture2.PNG.png

is there any possibility in Qlikview to do this? If yes please send me reply.

I have added QVW also

Thanks,

Chiru

3 Replies
mov
Esteemed Contributor III

Re: Req on Straight/Pivot table

Chiru,

Looks like the subtotals are by the "Bus Area' field.  In a pivot table, move the field to the left to make it the first dimension, and in Presentation tab check "Show Partial Sums" for the 2nd dimension.  You probably also want to check "Subtotals on top"

Keep in mind that subtotals are calculated only or expressions, so you may need to move some of your dimensions to expressions.

Regards,

Michael

Not applicable

Re: Req on Straight/Pivot table

Hi Michael,

Thanks for your reply.

I think you didn't change anything in my QVW, could you please do some changes on that QVW would be great help for me.

Thanks,

Vamsi

mov
Esteemed Contributor III

Re: Re: Req on Straight/Pivot table

Sorry, lost the changes.  See now.

Community Browser