Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
JoelTanSG
Contributor
Contributor

QlikView Countifs comparing current and previous month data

Hi All 

I've a table in QlikView:

ID Date Category
1 12/2021 A
2 12/2021 B
3 12/2021 B
1 01/2022 A
2 01/2022 B
3 01/2022 C
1 02/2022 B
2 02/2022 B
3 02/2022 A

 

I want to output the count of distinct IDs that was "A" in the previous month (Jan) and is now "B" in the current month (Feb).

so by right the only ID that satisfy the condition would be ID: 1 and the output should be 1

This is what I did and its not working:

//current month data
count(DISTINCT{$<[Date]={"$(=Max(Date))"},category={"A"}>}ID)
and
// previous month data
count(DISTINCT{$<[Date]={"$(=date((AddMonths(Max(Date),-1)),'MM-YYYY'))"},category={"B"}>}ID)

 

Labels (3)
0 Replies