topic Re: Within 2 weeks of a date in QlikView

Within 2 weeks of a date

brf10043 — Sat, 16 Nov 2024 00:55:00 GMT

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?

Re: Within 2 weeks of a date

lironbaram — Thu, 02 Apr 2020 16:15:56 GMT

it should be something like this :

count (if(today() - [end of life]<14 and today()>=[end of life],id))

Re: Within 2 weeks of a date

brf10043 — Thu, 02 Apr 2020 18:01:34 GMT

Thanks Lironbaram! I'll give that a try!

Re: Within 2 weeks of a date

brf10043 — Mon, 06 Apr 2020 17:32:26 GMT

Thanks Lironbaram,

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.