Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rmuhammad
Creator
Creator

p() and max()

Hi

How do I select only the select month + dec from previous years? I tried but it didnt work

I am getting all Decembers but missing current select month

Count({<[Year/Month],Period=

,Period={'=$(=max(Period))'}

,Period*=P({1<MONTH={$(=12)}>}Period)

,STATUS_CODE={'ACTIVE'}

,REG_TEMP={'REG'}

>} distinct EMPLID)

selection.png

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count({<[Year/Month], Period = {"$(=Max(Period))"}+p({1<MONTH={'12'}>}), STATUS_CODE = {'ACTIVE'}, REG_TEMP = {'REG'}>} DISTINCT EMPLID)

View solution in original post

1 Reply
sunny_talwar

May be this

Count({<[Year/Month], Period = {"$(=Max(Period))"}+p({1<MONTH={'12'}>}), STATUS_CODE = {'ACTIVE'}, REG_TEMP = {'REG'}>} DISTINCT EMPLID)

View solution in original post