Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tan_chungkam
Creator
Creator

Attendance Table (Crosstable?)

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?

My expected table in QliksenseMy expected table in Qliksense

Thank you.

Labels (5)
1 Solution

Accepted Solutions
Channa
Specialist III
Specialist III

ur measure need to be 

 

=only(Status)

 

it will help

Channa

View solution in original post

5 Replies
tan_chungkam
Creator
Creator
Author

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.

My table in QLiksenseMy table in QLiksenseMy scriptingMy scripting

miskinmaz
Creator III
Creator III

Hi,

What expression has been used.

tan_chungkam
Creator
Creator
Author

Hi @miskinmaz ,

Please find screenshot as my expression.

image.png

Channa
Specialist III
Specialist III

ur measure need to be 

 

=only(Status)

 

it will help

Channa
tan_chungkam
Creator
Creator
Author

Thanks for the solution.

It works perfectly.