Hello all, I'm having some trouble trying to convert my current Date field into Fiscal Quarters.
My current Date fields in the first column. I'd like to convert it, as so in the second column. Ideally, my Date field will start at October, November, December as Q1; Jan, Feb, March as Q2; and so forth.
Can anyone point me to any references on how to make this work? I've tried a few threads and was unsuccessful but if anyone had any pointers please feel free to drop a link! Much appreciated to all the Qlik gurus out there.