Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot Table

Hi, I have a question.

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

The result is like this:

pivot.PNG

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

Thanks in advance.

4 Replies
trdandamudi
Master II
Master II

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

dineshm030
Creator III
Creator III

Hi Chou,

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

jyothish8807
Master II
Master II

Hi Chou,

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

A sample screenshot below.

Regards

KC

Best Regards,
KC
Anil_Babu_Samineni

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

Capture.PNG

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful