topic Re: How to hide selected expression in pivot table in QlikView

How to hide selected expression in pivot table

Tue, 19 May 2015 08:13:37 GMT

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

Re: How to hide selected expression in pivot table

marcus_sommer — Tue, 19 May 2015 14:07:40 GMT

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

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

- Marcus

Re: How to hide selected expression in pivot table

qlikviewwizard — Thu, 02 Jul 2015 01:19:13 GMT

Hi revathikesari,

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

Re: How to hide selected expression in pivot table

vardhancse — Thu, 02 Jul 2015 02:33:16 GMT

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

Re: How to hide selected expression in pivot table

hariprasadqv — Thu, 02 Jul 2015 03:34:05 GMT

Hi,

Use conditional Enabeling of Expression.

Thanks

Re: How to hide selected expression in pivot table

settu_periasamy — Thu, 02 Jul 2015 04:10:59 GMT

Hi,

Try this.

uncheck the Show Partial Sum for Weekend date field only