topic Re: Id Count for Current Month vs Prev Month (Data Captured - weekly) in App Development

Id Count for Current Month vs Prev Month (Data Captured - weekly)

moh2_sid — Sun, 11 Aug 2024 21:50:14 GMT

Hi All,

Hope All is well!

I am new to using Qlik and need of help of the experts. I have a data set which gets updated weekly (Date -field) to capture Status of Apps, I am trying to build an KPI for Count of ID's - Curr vs Prev Month

I need help with the set analysis expression to capture ID's for Max Date of Last Month where status is 'No'. I tried to used "max(ADDMONTHS(Date,-1))' in my set analysis as below

(COUNT({<Date = {"max(ADDMONTHS(Date,-1))"}>}ID)).

but its considering 'JUL-02-24' , based on the max date of current month (08/02/24). Instead I want it to consider ''07-26-24", as it is max date for last month in my data set. Eg of the Data set in the below picture.

@Qrishna @rubenmarin

Hoping to get the solution from the experts.

Thanks for your help.

Re: Id Count for Current Month vs Prev Month (Data Captured - weekly)

Padma123 — Mon, 12 Aug 2024 07:20:00 GMT

use

(COUNT({<Date = {"$(=addmonths(max(date),-1)))"}>}ID))

Re: Id Count for Current Month vs Prev Month (Data Captured - weekly)

Kushal_Chawda — Mon, 12 Aug 2024 09:39:30 GMT

@moh2_sid try below

count({<Date = {'$(=date(max({<Date={">=$(=monthstart(addmonths(max(Date),-1)))<=$(=monthend(addmonths(max(Date),-1)))"}>}Date)))'}>}ID)

Re: Id Count for Current Month vs Prev Month (Data Captured - weekly)

moh2_sid — Tue, 13 Aug 2024 12:16:53 GMT

Thank you for you reply.

But It's still considering JUL-02-24 as date.