How will I get values matching with the codes

[kavita25]

I have attached the excel file.

In Excel I want to make One column for Codes and One column for Values.

And it should show data based on the Values and Codes

for e.g

Tran_Ref no 15/09417

Cal Code WGT in  CALCODE1  the values is 0.6

Result: One column with a name "CODE"

If i click on WGT same Ref no. it should show values 0.6 from One column "Values"

Regards,

Kavita

[kavita25]

Please help me with this issue...

Its Urgent...

[Anonymous]

Did not get, what exactly you want.

In QV this is automatic...no need to do anything

[#4]

Stack the columns in the load like this

LOAD UNIT_CODE&''&TRN_CODE&''&ITEM_CODE&''&STORE_CODE_FROM&''&STORE_CODE_TO as Code,
TRN_REF_NO,
TRN_LINE_NO,
REF_NO,
REF_LINE_NO,
ITEM_REV_NO,
ITEM_DESC,
STORE_CODE_FROM,
STORE_CODE_TO,
ITEM_UOM,
ITEM_QTY,
CONV_UOM,
ITEM_CONV_QTY,
ITEM_RATE,
CAL_CODE1,
VALUE1,
CAL_CODE2,
VALUE2,
CAL_CODE3,
VALUE3,
CAL_CODE4,
VALUE4,
CAL_CODE5,
VALUE5
FROM
TRN_DET - Copy.xls
(biff, embedded labels);

[Mark_Little]

Hi,

What exactly is it you are wanting?

if you importing the Excel document in to QlikView and then create a table and a couple of selectors you should have that automatically.

Mark

[kavita25]

I want one column for all the CAL_Codes column and one column for VALUE column

For e.g

Tran_Ref no 15/09417

If i click on

Cal Code WGT of CALCODE1, it should show 0.6

Have You checked the attachment....

There are 5 separate columns for Each CAL_Code and VALUES

[kavita25]

I want One column named as "CAL CODES " for all 5 separate columns of CAL_CODE1, CAL_CODE2,CAL_CODE3

CAL_CODE4, CAL_CODE5 and One column named as "VALUES" for 5 separate columns of VALUE1,VALUE2, VALUE3,  VALUE4,VALUE5.

I hope now you understand my requirement.

[Anonymous]

Take 5 resident of it,

and Concatenate all with same name

[Anonymous]

or at UI level in expression you can try:

CalCodes=1+2+3+4+5 so on

same for values

[kavita25]

I know this...There are 40 Calcodes lyk dis... I want some other solution....