topic Re: Straight table vs Pivot Table in QlikView

Straight table vs Pivot Table

jduenyas — Wed, 27 Jan 2016 23:16:27 GMT

Hi All

2 questions in one:

Why totals that show in Pivot table (highlighted in first screen shot) do not show in a straight table (second screen shot)

And why Mini Chart as in a straight table (framed highlighted in second screen shot ) is not available in a Pivot table?

In a pivot table it gives the total of the three months in question.

(All are calculated the same just changed from Straight to Pivot)

This is a pivot table

This is a straight table

Thanks

Re: Straight table vs Pivot Table

sunny_talwar — Wed, 27 Jan 2016 23:20:25 GMT

May be the totals for those three expressions are not enabled on the expressions tab. Make sure it is set to either Expression Total or Third option to be able to view a total up top.

Re: Straight table vs Pivot Table

sunny_talwar — Wed, 27 Jan 2016 23:22:28 GMT

For the last Column you can change the Representation to 'Text' from 'Mini Chart'

Re: Straight table vs Pivot Table

jduenyas — Wed, 27 Jan 2016 23:24:33 GMT

You are a genius!

I completely neglected those.

Thanks

Re: Straight table vs Pivot Table

Peter_Cammaert — Wed, 27 Jan 2016 23:25:19 GMT

And the answer to your second question: Mini-charts are available only in Straight Tables.

Check the Pivot Properties->Expressions->Representation list. No mini-charts.

Best,

Peter

Re: Straight table vs Pivot Table

jduenyas — Wed, 27 Jan 2016 23:27:08 GMT

Thanks

I learned that the hard way!!!