Discussion Board for collaboration related to QlikView App Development.
If I have an "end of life date" column and I want to count Ids where the end of life date is within 2 weeks of today's date but not yet passed, what would the expression look like?
it should be something like this :
count (if(today() - [end of life]<14 and today()>=[end of life],id))
View solution in original post
Thanks Lironbaram! I'll give that a try!
What if I want to create a Pie or bar chart hat divides the data into the buckets? What would the expression look like?
1 bucket for past date
1 bucket for 12 months until date
I bucket for 24 months until date.