Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
triekong
Creator
Creator

Date Issue in Straight Table

Hi All,

i am trying to display products and their dates on a straight table, but for some reason, they don't show up. The product IDs could be duplicate, but their date field is not the same. the ProductIDs only seems to be displayed when i include a function such as the "MAX(Sell By Date)" is used in the expression tab ( which i do not want to use because i want all the dates/times to show up for each ProductID).

However, when using a table box,the ProductIDs and Dates are displayed correctly.But for some reason, will not display correctly with a straight table. i have tried using the "DATE" function in the expression or the "TIMESTAMP(FLOOR(..." expression, but neither work.

I have also tried doing a format change under the 'Number' tab in properties, and that does not work either. Maybe i am missing something. Please suggest Options.

i have attached a copy of the file i am working with. Thanks!

1 Solution

Accepted Solutions
sunny_talwar

Why don't you use Sell By Date as a dimension?

Capture.PNG

View solution in original post

1 Reply
sunny_talwar

Why don't you use Sell By Date as a dimension?

Capture.PNG