topic Re: Date Issues in QlikView

Date Issues

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

Hi ,

i have a date field which is displaying how I wanted , the expression I have used is Date("recorded_at") as "Month/Year",

but it is splitting the date on each day in relation to the Service Type column,

How to get the Month/Year supposdely for example Oct 2016 we want to show collectively rather day by day.

sunny_talwar — Tue, 31 Jan 2017 13:17:03 GMT

May be like this:

Date(MonthStart("recorded_at"), 'MMM/YYYY') as "Month/Year"

Anonymous — Tue, 31 Jan 2017 13:28:10 GMT

Hi sunny .

It is working partially But i wanted like picture 2.

sunny_talwar — Tue, 31 Jan 2017 13:30:57 GMT

Use a pivot table and drag MonthYear dimension to the top of the chart

Anonymous — Tue, 31 Jan 2017 13:32:04 GMT

Oh ok .I did that earlier.

It is working.

So for a straight table is that possible?

sunny_talwar — Tue, 31 Jan 2017 13:34:17 GMT

Use an expression with set analysis....