How to hide selected expression in pivot table

[#1]

Hi All,

I have a pivot table for each weekend and there is a expression actual hours and budget hours . i have requirement to hide only Total Actual hours ( only bolded one , actual hours for week end date should be present and also there should be Total budget hours ) ?

say have i have 5 expression for each weekend date and have subtotal for all 5 expression in pivot table and i want to hide 2 expression only for total ..

is that possible?

	Weekend date	03-01-2015	03-01-2015	03-08-2015	03-08-2015	Total	Total
Fullname	Dept	Actual Hours	Budget Hours	Actual Hours	Budget Hours	Actual Hours	Budget Hours
Riya	Analytics	10	12	1	3	11	15
Rekha	Development	11	2	2	4	13	6

Thanks

[marcus_sommer]

You could query and react with dimensionality() and secondarydimensionality() the dimensions-level - like:

if(dimensionality() = 0, 'not calculated', sum([Actual Hours])

- Marcus

[qlikviewwizard]

Hi revathikesari,

Can you attach the application with the sample data. This will help the folks to give the answer quickly. Thanks.

[vardhancse]

Hi,

If you want to hide/show the expression you can use conditional expression. so based on the given condition the expression in pivot table will be visible/invisible.

Eg: =SubStringCount(Concat(%Met_No,'|',%Met_No),'01')=1

[hariprasadqv]

Hi,

Use conditional Enabeling of Expression.

Thanks

[settu_periasamy]

Hi,

Try this.

uncheck the Show Partial Sum for Weekend date field only