Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
In an attempt to get to even more closer to the look and feel of what you are looking for
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
!
Variations on the same.
Note that in Excel you can do layout things that you cannot reasonably mimic in QlikView without using extensions.
Best,
Peter
Check out the attached
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)
In an attempt to get to even more closer to the look and feel of what you are looking for
Here's my input on your question
Thank you sunny sunny for your help
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
It is a single straight table, I am not what else you looking to add? the top section?
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