Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
MalcolmCICWF
Creator III
Creator III

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
vishsaggi
Champion III
Champion III

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
vishsaggi
Champion III
Champion III

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.

MalcolmCICWF
Creator III
Creator III
Author

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

report back!

MalcolmCICWF
Creator III
Creator III
Author

That did work, thanks for the suggestion