Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have calculated the custom Quarters in Qlik sense as follows,
1.sep, oct,Nov - Q1
2.Dec,Jan, Feb-Q2
3.Mar,Apr, May-Q3
4.Jun, July,Aug - Q4
By this the QTD for example Count({<Year={$(=Max(Year))}, Quarter={$(=Max(Quarter))}>} DISTINCT IncidentID) not working any suggestions to make it work?
Can you try with max string(quarter)
If not works try using dual function
Can you try with max string(quarter)
If not works try using dual function