topic Re: Modify Date Format in Line Chart in QlikView

Modify Date Format in Line Chart

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

In line chart I have to show only MMM-YY format. Suppose a month has multiple dates so it is showing that many times MMM-YY. so how to restrict only once.

I am considering date as dimension in line chart.In chart I have to show only MMM-YY format.

Suppose a month has multiple dates so it is showing that many times MMM-YY so how to restrict only once.

Re: Modify Date Format in Line Chart

kaushiknsolanki — Thu, 10 Aug 2017 19:35:12 GMT

Try this.

=Date(Monthstart(DateFIeld),'MMM-YY')

Regards,

Kaushik Solanki

Re: Modify Date Format in Line Chart

its_anandrjs — Fri, 11 Aug 2017 06:26:29 GMT

Hi,

You can create another field is your load script

Load

Date( Monthstart ( C2_CUST_COMMIT_DT ),'MMM-YY') as MonthStartdate

from Location;

Regards

Anand

Re: Modify Date Format in Line Chart

bohravanraj — Fri, 11 Aug 2017 06:55:15 GMT

Hi Praveen,

It is always a best Practice to Take monthstart(Date) in Master Calendar as Month Year Field.

This will help in Rounding of Month and in dimension is will consider as single Month,

Regards,

Vanraj Dinesh Bohra

Re: Modify Date Format in Line Chart

qliksus — Fri, 11 Aug 2017 08:11:04 GMT

Try using trim function

Data:

LOAD * INLINE [
Date
01/01/2017
01/02/2017
01/03/2017
01/04/2017
01/05/2017
01/06/2017
01/07/2017
01/08/2017
01/09/2017
01/10/2017
];

Chart: