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: 
yasmeenk
Partner - Creator
Partner - Creator

How to display all the fields in a single straight table?

Hi all, I have excel file with certain data. I need to display all the fields in a single straight table.

I have attached the excel file

1 Solution

Accepted Solutions
sunny_talwar

In an attempt to get to even more closer to the look and feel of what you are looking for

Capture.PNG

View solution in original post

11 Replies
ziadm
Specialist
Specialist

Hi

Earning are you dimension and I do not think there is a way can make the table exactly the way you picture

Attached is very close what you want

!

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Variations on the same.

Payslips thread215570.jpg

Note that in Excel you can do layout things that you cannot reasonably mimic in QlikView without using extensions.

Best,

Peter

sunny_talwar

Check out the attached

Capture.PNG

Script:

Table:

LOAD Emp.No,

     Earnings,

     Rupees,

     Type

FROM

payslip.xls

(biff, embedded labels, table is Sheet2$);

TempTable:

LOAD *,

  If(Emp.No = Peek('Emp.No') and Type = Peek('Type'), RangeSum(Peek('Key'), 1), 1) as Key

Resident Table

Order By Emp.No, Type;

NewTable:

LOAD Key,

  Emp.No,

     Earnings,

     Rupees as EarningRs

Resident TempTable

Where Type = 'E';

Join (NewTable)

LOAD Key,

  Emp.No,

     Earnings as Deductions,

     Rupees as DeductionRs

Resident TempTable

Where Type = 'D';

DROP Table Table, TempTable;

Straight table

Dimension

Key (Hidden from Presentation tab)

Expressions

=If(Dimensionality() = 0, 'Total Earnings', Earnings)

=Sum(EarningRs)

=If(Dimensionality() = 0, 'Total Deductions', Deductions)

=Sum(DeductionRs)

sunny_talwar

In an attempt to get to even more closer to the look and feel of what you are looking for

Capture.PNG

Anonymous
Not applicable

Here's my input on your question

Not applicable

Thank you sunny sunny for your help

yasmeenk
Partner - Creator
Partner - Creator
Author

Thank you all. Mr.Sunny you are right but my issue is, I need to create everything in a single straight table that includes Emp No, name,etc in the same format as I posted above.

Thanks in advance.

Regards,

Yasmeen

sunny_talwar

It is a single straight table, I am not what else you looking to add? the top section?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Apparently...

Yasmeen, in NPrinting you can output all details to an Excel Worksheet just like in your screenshot. But in QlikView you may need additional objects (e.g. properly formatted and aligned text boxes) to visualise additional information. QlikView objects are highly data model driven and cannot be easily made to act like an free-form Excel worksheet.

Peter