Discussion board where members can learn more about Qlik Sense App Development and Usage.
In my app we have a date field that I am needing to convert to a Quarter Year format
so for a date of 2019 - 05 - 01 - 00:00:00
I am expecting to get a value of Q2-2019
However based on the expression I have, I am getting Q1.6666666666667 - 2019
The expression I am using:
Is there something I am doing wrong in my expression. There are some values where I am getting whole numberd for the quarter dates, but most of the values seem to be having the quarter date in decimals.
@aswinnar make sure that your DATEFIELD is in proper date format. Based on DATEFIELD you can set the below variables in main tab
SET DateFormat='YourDATEFIELDFormat'; SET TimestampFormat='YourDATEFIELDFormat';
or else I will try to modify your expression like below
View solution in original post
@aswinnar try below
That expression doesn't seem to be working. I am getting Q- as the result
Hi @Kush ,
The second expression is working for me. Thanks for the help!