<Urgent> How to display the compensations/bonuses paid to the employees QUARTERLY (Compensations given monthly).

[Nick36]

Hello everyone,

I am new to Qliksense. I have a monthly compensation/bonus datasets which I am trying to display Quarterly using Bar chart .

Please, Is there any simple expression I can use in Qliksense to display the compensation paid to the employees quarterly. 

Your help and suggestions will be highly appreciated.

Thanks in advance.

[Vegar]

Assuming you have a data set containing of a Period field in a YYYY-MM format, and an Amount field.

Load 

Period,

QuarterName(date#(Period,'YYYY-MM')) as Quarter,

Amount

From Source;

[Nick36]

Thanks alot Vegar, I just copied this part "=QuarterName(date#(Period,'YYYY-MM'))" into the expression editor and it gave me the result.