Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ryan_evans1984
Contributor
Contributor

Line Chart by Distinct Date

    I am looking to create a line chart by date.

   The date field 'dat Start' is currently DD:MM:YYYY:SS  and in the load script I used date(datStart,'DD-MM-YYYY') as DateX,

  

   to create a new date field. This works fine. So I then used this as my Dimension in a line graph and this does not give me the unique date ..... the date just gets repeated by the timestamp I assume.

I wanted Date 8/8/2018  - 9/8/2018 - 10/8/2018    by expression sum (Up) and sum(Down)

But I get the 8th repeated across the X axis

Can someone please suggest what I can do to achieve this ?

3 Replies
gp_oconnor
Partner - Contributor III
Partner - Contributor III

Try changing [date(datStart,'DD-MM-YYYY') as DateX] to [date(Floor(datStart),'DD-MM-YYYY') as DateX].

ryan_evans1984
Contributor
Contributor
Author

Thanks Gavin. Works great !

MarcoWedel

Date()‌ Is a formatting function that keeps your underlying distinct timestamp values.

You could use DayName(datStart) instead.

hope this helps

regards

Marco