Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prateek_a
New Contributor

Cross table with multiple fields

Hi All,

Please let me know whether we can convert row fields to column header format and load data in qlik. Please check attached.

Regards,

Pratik Advani

3 Replies
Khan_Mohammed
Honored Contributor II

Re: Cross table with multiple fields

Give more details on how you want it?

You XL sheet is not just rows...

The rows are messed up

attach an image and explain please..

prateek_a
New Contributor

Re: Cross table with multiple fields

Please check below screenshot which contains both original data and expected output.

Original data

Actual data.PNG

Expected output:

Expected output.PNG

Khan_Mohammed
Honored Contributor II

Re: Cross table with multiple fields

Ok,

whats the full data?

You just want these as columns?

if(A='TASKS COMPLETED',' ') as [TASKS COMPLETED],

if(A='TASKS IN PROGRESS',' ') as [TASKS IN PROGRESS],

if(A='TASKS TO BEGIN NEXT WEEK',' ') as [TASKS TO BEGIN NEXT WEEK],

if(A='URGENT ISSUES',' ') as [URGENT ISSUES],

if(A='SELF ASSESSMENT & COMMENTS',' ') as [SELF ASSESSMENT & COMMENTS]

From.....

I couldn't make a single field in Cross Table and it seem here we are removing values from dimension and using it as a dimension.

to be honest what goes inside those columns is more important... and how you want to link...

Just creating columns can be done in quite a few ways but that's not the answer for this.

Community Browser