topic Re: How to display the dates instead of having multiple dates field? in QlikView

How to display the dates instead of having multiple dates field?

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

I have date field and dates like

5/25/2018 1:16:25

5/25/2018 1:15:35

5/25/2018 2:40:12

5/24/2018 12:15:15

5/24/2018 12:15:29

My requirement is I want to display only date with out time and display the single date only instead of multiple dates.

Like. 5/25/2018

5/24/2018

Thanks

Re: How to display the dates instead of having multiple dates field?

Gysbert_Wassenaar — Thu, 31 May 2018 10:00:09 GMT

Cut off the time part using the floor function: Date(Floor(MyDate)) as MyDate

Re: How to display the dates instead of having multiple dates field?

gkcchowdary — Fri, 01 Jun 2018 10:47:00 GMT

Your solution working fine.

But I have one problem

If am using above expression .If I select any date after current selection box it showing number format.

Like 10 of 29437.

How display the dates in current selection box.

Re: How to display the dates instead of having multiple dates field?

Gysbert_Wassenaar — Fri, 01 Jun 2018 12:06:04 GMT

Cut of the time part of the date field in the load script. If you need the time parts then store those in a separate field.

Re: How to display the dates instead of having multiple dates field?

gkcchowdary — Wed, 08 Aug 2018 10:04:11 GMT

Hi Gysbert

if get any idea on below requirement please help on this.

I want do in back end level(script)

target date changed count the ID's.

I have table fields

table:

Issu_ID

date_upload

Taget_date

-> KPI chart if the user selects any two dates compare those two dates.if maximum date and maximum previous dates in the Taget_date field are different then caluclate the count id's.

Example:

Issue_ID Date_upload Target_date

01 01-01-2018 10-05-2018

01 03-01-2018 15-05-2018

02 01-01-2018 10-05-2018

02 03-01-2018 10-05-2018

03 01-01-2018 10-05-2018

03 03-01-2018 16-05-2018

In the above table if we select dates in the date upload field i.e., 01-01-2018 and 03-01-2018 then count is 2 because id 01,03 target dates are changed and id 02 target dates are not changed.

so just count the Issues_ID when user select any two dates(ex:01-01-2018 is min date and 03-01-2018 is max date)compare those two dates if min date targetdate is onedate and max date targetdate is change to another date than caliculate the Issues_ID count.

I need quires for the above requirements in the back-end level.and write the expression front end level also if any simple way.

I have written quires in the front end level but the performance is slow and it is showing an error in the chart i.e., time out.

Thanking you.