topic Re: Please kindly assist . in QlikView

Date field not working properly

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

How to show the date_created as '2018-07-25' as it got 3 different timestamp.

My requirement -

to show '2018-07-25' on one line as it is a pivot table instead of three line coming ,

I used this set analysis in dimension

=Date ( Aggr(Min(TOTAL <batch_ref> (date_created)), batch_ref, (date_created)) )

, but still getting three rows .like this

Thanks .

sunny_talwar — Fri, 27 Jul 2018 11:53:29 GMT

Convert your timestamp to date using a calculated dimension

Date(Floor(date_created))

mtucholski — Fri, 27 Jul 2018 11:54:23 GMT

Hi,

please change the topic so it would serve it's job.

When it comes to your question, try this one:

floor(date_created)