Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
tan_chungkam
Contributor

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?

image.pngMy expected table in Qliksense

Thank you.

1 Solution

Accepted Solutions
Channa
Valued Contributor III

Re: Attendance Table (Crosstable?)

ur measure need to be 

 

=only(Status)

 

it will help

Channa
5 Replies
tan_chungkam
Contributor

Re: Attendance Table (Crosstable?)

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.

image.pngMy table in QLiksenseimage.pngMy scripting

miskinmaz
Contributor II

Re: Attendance Table (Crosstable?)

Hi,

What expression has been used.

tan_chungkam
Contributor

Re: Attendance Table (Crosstable?)

Hi @miskinmaz ,

Please find screenshot as my expression.

image.png

Channa
Valued Contributor III

Re: Attendance Table (Crosstable?)

ur measure need to be 

 

=only(Status)

 

it will help

Channa
tan_chungkam
Contributor

Re: Attendance Table (Crosstable?)

Thanks for the solution.

It works perfectly.