Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to hide selected expression in pivot table

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 date03-01-201503-01-201503-08-201503-08-2015Total Total
FullnameDept Actual HoursBudget HoursActual HoursBudget HoursActual HoursBudget Hours
RiyaAnalytics1012131115
RekhaDevelopment11224136

Thanks

5 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

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

- Marcus

Highlighted
Master II
Master II

Hi revathikesari,

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

Highlighted
Specialist III
Specialist III

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

Highlighted
Creator III
Creator III

Hi,

Use conditional Enabeling of Expression.

Thanks

Highlighted

Hi,

Try this.

uncheck the Show Partial Sum for Weekend date field only

Help3.JPG