Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

return the last month

I have a year filter, if I select 2017, it returns 12 (last month in 2017). If select 2018, it return 5 (current month).

Is that possible?

2 Replies
Digvijay_Singh
Honored Contributor III

Re: return the last month

I think Max(Month) will respond as per your selection and needs

rafatashiro
New Contributor III

Re: return the last month

I think U can try count( distinct Month) too

Community Browser