topic Re: Basic AR Measure Range Issue in QlikView

Basic AR Measure Range Issue

Tue, 15 Nov 2016 16:20:42 GMT

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.

Re: Basic AR Measure Range Issue

shraddha_g — Tue, 15 Nov 2016 16:25:26 GMT

Try

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

Re: Basic AR Measure Range Issue

Anonymous — Tue, 15 Nov 2016 16:29:44 GMT

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

Re: Basic AR Measure Range Issue

Anonymous — Tue, 15 Nov 2016 16:33:47 GMT

with that you can handle them in script

‌

Re: Basic AR Measure Range Issue

Tue, 15 Nov 2016 18:04:48 GMT

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