topic Re: Line Chart by Distinct Date in QlikView

Line Chart by Distinct Date

ryan_evans1984 — Thu, 09 Aug 2018 15:09:52 GMT

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 ?

Re: Line Chart by Distinct Date

gp_oconnor — Fri, 10 Aug 2018 06:15:46 GMT

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

Re: Line Chart by Distinct Date

ryan_evans1984 — Fri, 10 Aug 2018 07:28:02 GMT

Thanks Gavin. Works great !

Re: Line Chart by Distinct Date

MarcoWedel — Fri, 10 Aug 2018 20:48:45 GMT

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

You could use DayName(datStart) instead.

hope this helps

regards

Marco