Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
aamertaimor
Contributor III
Contributor III

Dates and count is not correct

hi,

In attached file  i have populated missing data but there are two problems with the output

1) count is showing 4204. Although it should be 115 as  it does with distinct count.  I don't understand where this 4204 comes from although i have removed all data from final load?

2) Final date format is dd/mm/yyyy hh:mm:ss but i want this to format in script as dd/mm/yyyy. I tried Date(Date#) but its not working. I can work around this in front end but i want to do this in script.

Thanks.

1 Reply
Anonymous
Not applicable

1) when you check the number of rows in your table you'll find the 4204

    in the table you see less, as many datarows are identical and therefor only Show once

    try to use a distinct in your select statements

2) you cam doit in script (recommended if you always Need date and not time)

   date(Reporting Date) as [Reporting Date]

or in table use tab number ReportingDate and Overreide data Format with "Date"