topic Month Count in QlikView

Month Count

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

Hi All,

Please if any one can help me on the solution.

I need to get the data for the previous months. For Eg:- If year is 2017 and Month selected is April then i should get the count records of (Jan+Feb+March+April). If i click March then it should get the count records of (Jan+Feb+March)

its bit urgent.

Thanks in Advance!!

Re: Month Count

vishsaggi — Wed, 19 Apr 2017 15:53:10 GMT

Can you share a sample to look into and work on?

Re: Month Count

devarasu07 — Wed, 19 Apr 2017 15:53:21 GMT

Try like this,

SUM({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} SoldQty)

Re: Month Count

devarasu07 — Wed, 19 Apr 2017 16:07:33 GMT

Hi,

Refer to the attached sample, just use below kind of expression (productid changed to your field)

for the count,

Count({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} ProductId)

Re: Month Count

Anonymous — Wed, 19 Apr 2017 16:28:40 GMT

Thanks Devarasu. This is what i was looking for.