Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
brf10043
Creator
Creator

Within 2 weeks of a date

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?

Labels (2)
1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi 

it should be something like this : 

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

 

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

it should be something like this : 

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

 

brf10043
Creator
Creator
Author

Thanks Lironbaram!  I'll give that a try!

brf10043
Creator
Creator
Author

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.