topic Pivot Table in QlikView

Pivot Table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a question.

I have a pivot table with no dimension and two expressions.

The result is like this:

Is it possible to omit the top part (blue circle), if possible how can i do this ?

Thanks in advance.

trdandamudi — Thu, 03 Nov 2016 01:33:24 GMT

Go to properties tab of the pivot table and select "No Totals" under the "Total Mode" box. Hope this helps...

dineshm030 — Thu, 03 Nov 2016 05:59:38 GMT

Hi Chou,

Go to Expression Tab, Select the "No Totals" for both Expression under "Total Mode" option.

jyothish8807 — Thu, 03 Nov 2016 06:04:36 GMT

Hi Chou,

First give a label to you expression if required. Then select "No Total" .

A sample screenshot below.

Regards

Anil_Babu_Samineni — Thu, 03 Nov 2016 07:32:36 GMT

You can UN-check Partial Sum too. Try Luck because above 2 replies are rocket grow