Discussion Board for collaboration related to QlikView App Development.
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
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