Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
Thanks alot Vegar, I just copied this part "=QuarterName(date#(Period,'YYYY-MM'))" into the expression editor and it gave me the result.