Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dseelam
Creator II
Creator II

totals & subtotals

Hello All,

attached image is a pivot table fully expanded with units and sales $ as expressions when I move units and dollars separated manually and apply partial sum on LFT Account name this yellow marked totals are coming up how to avoid them?

Is this a bug of some kind

dseelam_0-1591375669119.png

 

Labels (3)
1 Solution

Accepted Solutions
dseelam
Creator II
Creator II
Author

yes I found it the yellow colored row is nothing but month year has been converted in to num(date) 

 

I did a simple date format trim(date(field),mmm-yyyy)

View solution in original post

1 Reply
dseelam
Creator II
Creator II
Author

yes I found it the yellow colored row is nothing but month year has been converted in to num(date) 

 

I did a simple date format trim(date(field),mmm-yyyy)

View solution in original post