topic Re: count per period in QlikView

count per period

curiousfellow — Fri, 15 Jan 2016 11:04:07 GMT

In my load script i create a field named period with date(calenderdate,'YYYY-MM').

works fine

now i want a chart with number of invoices per period.

dimension : period

expression : =count(invoice)

In my chart sometimes a period is displayed twice with different results. Other periods are displayed once in that chart.

Cannot figure out why this happens. Should be a very simple chart.

Re: count per period

robert_mika — Fri, 15 Jan 2016 11:06:43 GMT

Try:

Date(monthstart(calenderdate), 'YYYY-MM') as period,

Feeling Qlikngry?

How To /Missing Manual(24 articles)

Re: count per period

sunny_talwar — Fri, 15 Jan 2016 11:07:21 GMT

Create a MonthYearField one of these ways to make it work:

MonthName(calendardate) as period

Date(MonthStart(calendardate), 'YYYY-MM') as period

Re: count per period

curiousfellow — Fri, 15 Jan 2016 12:18:29 GMT

Thank you both, it worked.

So Qlikview still remembers the original date, allthough i created a new field ?

Otherwise I do not understand why this happens

Re: count per period

sunny_talwar — Fri, 15 Jan 2016 12:22:29 GMT

This happens because just because you formatted Date as YYYY-MM doesn't mean that date information is gone. It is still a date (02/05/2016) represented as 2016-02. So for each distinct date you see a different YYYY-MM. But MonthName and MonthStart helps you resolve this issue.