Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
gkcchowdary
Creator
Creator

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

Hi

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

gkcchowdary
Creator
Creator
Author

hi

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.

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
gkcchowdary
Creator
Creator
Author

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.