topic Re: Req on Straight/Pivot table in QlikView

Req on Straight/Pivot table

Mon, 06 Oct 2014 16:19:48 GMT

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:

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

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

I have added QVW also

Thanks,

Chiru

Re: Req on Straight/Pivot table

Anonymous — Mon, 06 Oct 2014 16:46:18 GMT

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

Re: Req on Straight/Pivot table

Mon, 06 Oct 2014 18:05:49 GMT

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

Re: Re: Req on Straight/Pivot table

Anonymous — Mon, 06 Oct 2014 18:16:19 GMT

Sorry, lost the changes. See now.