topic Pivot table subtotal coloumn removal in QlikView

Pivot table subtotal coloumn removal

Fri, 17 Dec 2010 10:52:02 GMT

Hi Guys

How should I remove subtotals row without affecting other calculations .

Please let me help for the same expecting quick reply from anybody .

Regards

Go....COOL

Pivot table subtotal coloumn removal

Miguel_Angel_Baeyens — Fri, 17 Dec 2010 11:02:53 GMT

Hello,

If you are using a straight table, then go to the chart properties, Expressions tab, click on the expression you want to remove subtotal, and select "Total Mode", "No totals". If you are using a pivot table, then uncheck the "Show partial sums" in the "Presentation" tab.

Hope that helps.

Pivot table subtotal coloumn removal

Fri, 17 Dec 2010 11:22:15 GMT

Thanks for the reply

but I want to remove that coloumn still its displaying that coloumn

Whenever I'll change that presentation -subtotals on top or bottam I'm getting changed those values there position but I'm not getting removed that perticular row ......

Please reply me

Pivot table subtotal coloumn removal

Miguel_Angel_Baeyens — Fri, 17 Dec 2010 11:42:25 GMT

I'm afraid I'm missing something. First, what chart are you using? Second, what column do you want to remove? It's a calculated column? In this case remove/disable the expression.

Pivot table subtotal coloumn removal

Fri, 17 Dec 2010 12:52:28 GMT

Hi Miguel ,

Thanks for such quick replies .

Actually now I.m sending screenshot of perticular pivot table .I want to remove that perticular marked row from table I had tried your suggestions but it doen't allow me to do remove that coloumn actually this is calculated field .Hope you'll reply quickly

Pivot table subtotal coloumn removal

Fri, 17 Dec 2010 12:56:23 GMT

Hi I had tried supree null value option but it affects calculations ..........

Please suggest some approach......

Pivot table subtotal coloumn removal

Mon, 20 Dec 2010 14:18:53 GMT

Anybudy can reply me please .......

I had this question because I'm not able to get actual calculations and values due to the selection of supress null value option fro properties ......

Pivot table subtotal coloumn removal

Thu, 30 Dec 2010 07:02:52 GMT

Hi Guys I'm sending application please give me idea .

Pivot table subtotal coloumn removal

marcohadiyanto — Thu, 30 Dec 2010 07:09:58 GMT

hi,

that's not subtotal,

you can try this:

go to your table, properties -> Dimension->support Month

and then setting for Selected dimension check 'Suppress when value is null'

regards,

Marco

Pivot table subtotal coloumn removal

Thu, 30 Dec 2010 07:13:16 GMT

Hi Marco ,

That option I tried but calculations get affected .

Please reffer attached excel sheet for problem and various approaches I had tried

Pivot table subtotal coloumn removal

Thu, 30 Dec 2010 10:11:47 GMT

How about this:

On [Support Month] dimension, TextColor expression set to

if( [Support Month]='*', rgb(255,255,255))

Set the same for the expression TextColor.

It sort of 'hide' it. I saw you using this as one of your attempt. So I don't think you mind this. Hope this helps.

Pivot table subtotal coloumn removal

Thu, 30 Dec 2010 11:17:53 GMT

Hi Friend it wont work in my case I had tried thi one

Pivot table subtotal coloumn removal

Thu, 30 Dec 2010 16:23:29 GMT

what expression did you use?

when you said it's not working, does that mean the textcolor doesn't change to white?