Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Basic AR Measure Range Issue

I am new to Qlik and nor a developer.  Trying to simple creating Acct Receivables measures based on age of invoices.

I am trying to get Current, 30-60, 60-90, over 90 for my invoices.

For example, Current: is Sum({$<[Aging Days]={'<=30'}>} Balance)

I am struggling with the right way (or any way) to limit my set expression when it comes to a range, like 30-60 days.  This is based on a field called "Aging Days"

Any help is appreciated.

RG

4 Replies
shraddha_g
Partner - Master III
Partner - Master III

Try

Sum({$<[Ageing Days]  ={'>30 <=60'}>}Balance)

Anonymous
Not applicable
Author

‌Try with class function. Also apply map or map functions also would serve your need. Just look at their examples it would help you.

Anonymous
Not applicable
Author

with that you can handle them in script

Not applicable
Author

Thanks, that worked. I thought I had tried it, but I guess I didn’t.