Discussion board where members can get started with Qlik Sense.
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?
My expected table in Qliksense
Go to Solution.
ur measure need to be
it will help
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.
My table in QLiksenseMy scripting
What expression has been used.
Hi @miskinmaz ,
Please find screenshot as my expression.
Thanks for the solution.
It works perfectly.