Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try
Sum({$<[Ageing Days] ={'>30 <=60'}>}Balance)
Try with class function. Also apply map or map functions also would serve your need. Just look at their examples it would help you.
with that you can handle them in script
Thanks, that worked. I thought I had tried it, but I guess I didn’t.