Quarter Formula showing Q - Error

[Pragya]

Hi All,

I used Qlik desktop before and now started working on Qlik server.

I used this formula to create quarters in the dashboard and it used to work fine. Now from the time I have started working on Qlik Server, it just shows Q.

Could anyone please advise what is wrong or what am I missing. The formula is

Year(Date#(ArrivalDate, 'YYYY-MM-DD')) & 'Q' & Ceil(Month(Date#(ArrivalDate, 'YYYY-MM-DD'))/3) as ArrivalYearQtr,

Please advise.

Thanks and Regards

[Surya · Accepted solution]

Hello,

'Q' & Ceil(Month(num#(ArrivalDate))/3)

[tresesco]

The issue is probably with the data format. Check if the date values are really coming in desired format ('YYYY-MM-DD'). If this format doesn't match, the date#() would fail to fail the entire statement.