Date Issue in Straight Table

triekong — Mon, 23 Oct 2017 17:47:22 GMT

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!

Re: Date Issue in Straight Table

sunny_talwar — Mon, 23 Oct 2017 17:50:14 GMT

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

topic Date Issue in Straight Table in QlikView

Date Issue in Straight Table

Re: Date Issue in Straight Table