Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm dealing with HR department report which is an attendance report.
Please find attached my excel file data in 'Sheet1'.
I would like to make a exactly same structure table as below screenshot.
I tried to use pivot table but not the outcome as below screenshot.
I guess it must be done something in scripting.
Is there anyways to do it?
Thank you.
Quick Update:
I successful did something in Qliksense as below screenshot.
However i wish the table content from '1' turn into their own content such as 'AL', 'PH', 'FA' and etc.
Hi,
What expression has been used.
ur measure need to be
=only(Status)
it will help
Thanks for the solution.
It works perfectly.