Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.