You might have spent some time trying out different ways. I suggest you to spend a bit more time to create a sample app (if not already there) and share to work on.
Sure. Maybe I thought i'd make it an expression with count If instead.
count(distinct (If( not isnull(unitnumber)) and (count(distinct(donationdate>=2) and interval(max(donationdate)-(max(donationdate)-1),'m')<=24 and max(donationdate)..?. , donors )
As for max(donationdate) belonging in the last 12 months I don't have a solution. Maybe addmonths?
Any thoughts? I am quite new to qlik and trying to learn. You are helping a lot !
Not necessarily. However, there are many things you have to take into consideration while writing an expression for solving a issue/query, like - selection state, object where the output is expected, ... Once you have everything clear in requirement/mind you can start writing/thinking about the expression. Since you have started learning, I would suggest to create a sample app and work on that - starting from writing simpler query solving expression to slowly moving towards more complex ones.
This is what I am trying to do. Can you help me out with what I should do with this condition "max(donationdate) belonging in the last 12 months" and maybe I can figure the rest out.
