Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Removing totals from date columns on pivot table

Hello everyone,

I have the pivot table below and I need to remove the dates from the Total row for the date columns.

The Expressions Total Mode is already setup as No Totals but it seems that is ignored on pivot tables.

I definitely need the dates in the chart. Is there a way to this without getting rid of the date columns?

(I already have the same info in a straight table but the users need to be able to pivot the data on those 3 dimensions)

Thank you for any advice you can give me.

Miguel Gavidia

1 Solution

Accepted Solutions
Highlighted

May be use Dimensionality() function to populate Date for only the rows:

If(Dimensionality() = 3, Expression4InquiryDate)

Similarliy for the RentedDaye

If(Dimensionality() = 3, Expression4RentedDate)

View solution in original post

2 Replies
Highlighted

May be use Dimensionality() function to populate Date for only the rows:

If(Dimensionality() = 3, Expression4InquiryDate)

Similarliy for the RentedDaye

If(Dimensionality() = 3, Expression4RentedDate)

View solution in original post

Highlighted
Creator
Creator

Sunny,

That tip did the trick. Thank you very much!

Miguel Gavidia