topic Re: Open orders, by year-month and by time range in App Development

Open orders, by year-month and by time range

Charles80 — Sat, 19 Aug 2023 02:13:50 GMT

Hello friends. I'm facing a challenge here at qlik sense. I have the following situation: a chart shows the historical count of open orders by year and month, in a hierarchy dimension. So far everything working.

Now it has been requested that the chart also show the separation of these orders by 2 time bands. Orders open for up to 3 months and open for more than 3 months.

Can anyone help with a way to make this second dimension?

Thanks.

Re: Open orders, by year-month and by time range

robert99 — Sat, 19 Aug 2023 12:15:30 GMT

Hi @Charles80

With Qlik you can't link to a date dimension using set analysis. So, 'IF' must be used

This measure worked for debtors. I wanted the age of debtors going back in time, My dimension was AsofMthYear. The measure was (for aging 30 to 60 days)

sum({<CanonType = {TransDate} ,GLTransType = {ARDetail,ARAllocate} //enter as required

,MonthYear = , WeekEnding= // to ignore selections as appropriate

if( ARInvDate +60 >= monthend(AsOfMthYr) and ARInvDate +30 < monthend(AsOfMthYr)

,ARValue))

You would need something like

If (orderDate +90 > MonthEnd (AsofMthYear), //in one column

If (orderDate +90 <= MonthEnd (AsofMthYear), //in another column

Or something like the above.

Hope this is helpful

Robert

Re: Open orders, by year-month and by time range

Charles80 — Wed, 23 Aug 2023 20:41:36 GMT

Hi @robert99 , thank you for your return friend. In fact, I managed to solve it in another way, using temporary tables and IntervalMacth. Thank you very much.