Open orders, by year-month and by time range

[Charles80]

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. 

[robert99]

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

[Charles80 · Accepted solution]

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.