topic Re: How to hide total from Pivot table in QlikView

How to hide total from Pivot table

Fri, 17 Feb 2017 09:19:15 GMT

Please find the attached my requirement. In Pivot table I just wanted to hide Total of all rows except first one.

Not able to do that , please help.

Message was edited by: Vishal Patil

Re: How to hide total from Pivot table

surendraj — Fri, 17 Feb 2017 10:08:02 GMT

Properties-->Expressions-->

select the expression-->Total mode-->enable..No totals.

Re: How to hide total from Pivot table

Fri, 17 Feb 2017 10:45:28 GMT

I want Sum of first record i.e Cash and for rest I dont want.

I am using Pivot table.

Re: How to hide total from Pivot table

surendraj — Fri, 17 Feb 2017 10:58:09 GMT

Use the set expression in expressions tab

Sum({<level1={'Cash'}>}Market Value)

Note:Here i consider Level1 as afield name and Cash as field value.

Re: How to hide total from Pivot table

Fri, 17 Feb 2017 11:15:28 GMT

With this I am not able to display records from 2nd record onwards.

You can use below data for the same.

Data:

LOAD * INLINE [

Level1, Level2, Market Value

Cash, Investment Cash, 100

Cash, Deposits, 200

Fixed Income, Other Fixed Income, 500

Equities, US SMID Cap Equities,900];

Re: How to hide total from Pivot table

surendraj — Fri, 17 Feb 2017 11:31:05 GMT

Do you want this..

Re: How to hide total from Pivot table

Fri, 17 Feb 2017 11:53:15 GMT

Hi Surendra ,

I need below result.

Re: How to hide total from Pivot table

vinieme12 — Fri, 17 Feb 2017 11:57:49 GMT

can you provide in excel format?

Re: How to hide total from Pivot table

Anonymous — Fri, 17 Feb 2017 11:58:49 GMT

Please check the attachment.

Re: How to hide total from Pivot table

Fri, 17 Feb 2017 12:07:14 GMT

Please note that the option "Always Fully Expanded" will always on , so if I expand it I will not see the desired result.

Re: How to hide total from Pivot table

Fri, 17 Feb 2017 12:08:25 GMT

Requirement is below

Re: How to hide total from Pivot table

avinashelite — Fri, 17 Feb 2017 13:46:46 GMT

if you need the total for only cash Leve1 then as per my knowledge handling this in the front end would be difficult .....we need play around the script

Re: How to hide total from Pivot table

vinieme12 — Fri, 17 Feb 2017 13:51:48 GMT

See attached

Re: How to hide total from Pivot table

avinashelite — Fri, 17 Feb 2017 13:59:06 GMT

I think your losing the Level2 data hear ? for other values except cash ?

Re: How to hide total from Pivot table

vinieme12 — Fri, 17 Feb 2017 14:00:32 GMT

that matches the requirement so specifically suppressed it

We can choose to show both ways

Re: How to hide total from Pivot table

avinashelite — Fri, 17 Feb 2017 14:36:09 GMT

I did not checked your file sorry , I went with the data show in the image

Re: How to hide total from Pivot table

vinieme12 — Fri, 17 Feb 2017 14:39:41 GMT

not a prob buddy , happens with most of us

Re: How to hide total from Pivot table

Fri, 17 Feb 2017 16:49:22 GMT

You are correct Vineeth and Thanks for your help