topic Re: Make an MonthCounter in QlikView

Make an MonthCounter

Wed, 18 Feb 2015 08:31:58 GMT

Hello,

in my calendar do I have an 'InvoicePeriodCounter' and every month has two invoice periods.

Though I want to show current month -1 it doesn´t work over the year end.

How do I create the counter for the month over all years?

Example:

jan15 1

jan31 1

feb15 2

dec31 24

jan15 25

jan31 26

etc

Period_counter:
Load distinct
[Flag] as [Flag1],
[InvoiceYearMonth],
[InvoiceMonthNum] as [InvoiceMonthCounter],
recno() as [InvoicePeriodCounter]
resident tPeriod_counter
order by [Flag] asc;

kindly

Håkan

Re: Make an MonthCounter

israrkhan — Wed, 18 Feb 2015 08:37:31 GMT

i did not get you,

would you like to explain a bit more?

what is expected output?

Re: Make an MonthCounter

Wed, 18 Feb 2015 09:14:33 GMT

In the period_counter table do I expect a new column with a counter like the example below.

Re: Make an MonthCounter

Wed, 18 Feb 2015 09:17:42 GMT

oops! my Picture disappeared

Re: Make an MonthCounter

daveamz — Wed, 18 Feb 2015 10:32:16 GMT

Hi Håkan,

You can transform YearMonth in MonthID using AutoNumber([InvoiceYearMonth]). Then you can use MonthID-1 regardless of year.

Best regards,

David

Re: Make an MonthCounter

timanshu — Wed, 18 Feb 2015 11:11:12 GMT

Can you give a more clearer picture of your doubt??

Do you want counter value to increment by one for each entry with in a month or you want counter value to remain same for multiple entries with in a month??

Re: Make an MonthCounter

marcus_sommer — Wed, 18 Feb 2015 12:14:06 GMT

Maybe this is helpful: http://community.qlik.com/message/563904#563904

- Marcus