How to transpose date from row to column level?

[rupaliqlik]

Hi Team,

In my application, I have to show payroll related data. I have Reason Flag in my application ,by using that I am creating flag like Privilege Leave, Planned Leave …etc. But in my application attendance date is one field and they want to see each date as column. I have to transpose date from row to column. By using generic keyword I can create each date but my  dates are from 2021 and that's why datamodel is become complicated. Is there any other way to achieve this result.

MDOID is Primary key.

In Qliksense:

Excel data: Expected Result.

Attendance data, Present Days (P),
Privilege Leave (PL),Planned Leave (CL),Unplanned Leave (SL),Leave without Pay (A),Not Marked (NM),Total Holidays, Total Days.

thanks,

Rupali Ethape

@abhijitnalekar ,sunny_talwar ,Kaushik Solanki

[MayilVahanan]

Hi 

 "But in my application attendance date is one field and they want to see each date as column".

-- Did u try with Pivotal table to achieve in front end instead of backend script? Perhaps, it will help you .

[rupaliqlik]

Yes,I have used Pivot table and checked fully expand .but then they get the data in excel group format.