topic Re: Current Month Value in QlikView

Current Month Value

Tue, 16 Feb 2016 07:24:57 GMT

Hi ,

I want to display the count of New managers in the Current month but a not a manager in the previous month.

Addition of Manager in Current Month.

example: consider current month is Feb

Month Manager Id

Jan A 1

Jan B 2

Jan C 3

Month Manager Id

Feb A 1

Feb B 2

Feb D 5

Feb E 6

now count of new Managers in Current Month (Feb) is 2

Any Help would be appreciated.

Thanks,

Kavya

sunny_talwar — Tue, 16 Feb 2016 10:09:15 GMT

May be this:

=Count(DISTINCT {<MonthNum = {'$(=Max(MonthNum))'}, ID = e({<MonthNum = {'$(=Max(MonthNum) - 1)'}>})>}ID)

Tue, 16 Feb 2016 11:47:52 GMT

Hi Sunny

i want output in chart like this.

Thanks,

Kavya

sunny_talwar — Tue, 16 Feb 2016 21:20:38 GMT

Not sure how this would look if you have more than 2 months. But for two months the same expression seems to work:

Wed, 17 Feb 2016 01:01:24 GMT

I want to display for more than two months

sasikanth — Wed, 17 Feb 2016 05:34:38 GMT

hi,

Try this exp

=Count(DISTINCT {<MonthNum = {'$(=Max(MonthNum))'}, ID = e({<MonthNum = {'<$(=Max(MonthNum))'}>})>} ID)