topic Re: How to transpose date from row to column level? in QlikView

How to transpose date from row to column level?

rupaliqlik — Wed, 27 Apr 2022 05:51:27 GMT

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

Re: How to transpose date from row to column level?

MayilVahanan — Mon, 25 Apr 2022 02:33:15 GMT

"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 .

Re: How to transpose date from row to column level?

rupaliqlik — Mon, 25 Apr 2022 10:04:46 GMT

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