Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

Values not grouping by field in table

I have not had this issue amongst other reporting, and I'm not sure if it has to do with the date field having a time stamp before I am reformatting it, but let me know what you think. The data is pretty straight forward, but wont roll up under the same Client or Date field...

Capture.PNG

1 Solution

Accepted Solutions
Highlighted
Esteemed Contributor III

Re: Values not grouping by field in table

Yes, i think its due to reformatting internally that date still holding timestamp. Try using format like Floor() or Num() around your dates creating a new field.

View solution in original post

3 Replies
Highlighted
Esteemed Contributor III

Re: Values not grouping by field in table

Yes, i think its due to reformatting internally that date still holding timestamp. Try using format like Floor() or Num() around your dates creating a new field.

View solution in original post

Highlighted
Contributor II

Re: Values not grouping by field in table

Ok that's the only think I could think of causing the problem. Good suggestions, let me try that and I'll

report back!

Highlighted
Contributor II

Re: Values not grouping by field in table

That did work, thanks for the suggestion