QTD calculations

[Raju_6952]

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?

[anat · Accepted solution]

Can you try with max string(quarter) 

If not works try using dual function