topic Create fixed format like in excel in qlikview in QlikView

Create fixed format like in excel in qlikview

kushalthakral — Tue, 08 Apr 2014 04:28:47 GMT

Dear All

Need help regarding creating fixed format as in excel in qlikview like below:

Months	Oct-12	Nov-12	Dec-12	Jan-13
Budgeted Production Plan
ABC
XYZ

CEF

ZCX
Opening RM Inventory
Local
Import
Transit
Consumption
Local Consumption
Import Consumption
New Purchase
Local
Import
Receipts at Plant
Purchase Plan - Local
Purchase Plan - Import
Expected Closing Inventory
Local w/o ABC
No Of Days
Import w/o CDE
No Of Days
Material In Transit
No Of Days
TOTAL RM (Incl MIT) without ABC
Cover Days
WIP
No Of Days
Finished Goods
No Of Days
Sub Total
TOTAL INV. - CAR PLANT Without ABC
No of Days without ABC

Re: Create fixed format like in excel in qlikview

Tue, 08 Apr 2014 04:37:08 GMT

Use a customised sort.

Use an expression similar to the below in your Sort.

=Match('Budgeted Production Plan','ABC',XYZ','CEF', ................................)

Re: Create fixed format like in excel in qlikview

kushalthakral — Tue, 08 Apr 2014 04:39:57 GMT

Hi Ramkumar

Actually the format is fixed and column content is not available in table i just wanted to show the Table view in which first column remains same and calculated expression in other columns.