topic Re: How will I get values matching with the codes in QlikView

How will I get values matching with the codes

kavita25 — Fri, 06 Nov 2015 10:50:20 GMT

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

Re: How will I get values matching with the codes

kavita25 — Fri, 06 Nov 2015 12:35:54 GMT

Please help me with this issue...

Its Urgent...

Re: How will I get values matching with the codes

Anonymous — Fri, 06 Nov 2015 12:42:29 GMT

Did not get, what exactly you want.

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

Re: How will I get values matching with the codes

Fri, 06 Nov 2015 12:44:32 GMT

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);

Re: How will I get values matching with the codes

Mark_Little — Fri, 06 Nov 2015 12:48:50 GMT

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

Re: How will I get values matching with the codes

kavita25 — Fri, 06 Nov 2015 12:53:01 GMT

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

Re: How will I get values matching with the codes

kavita25 — Fri, 06 Nov 2015 13:01:04 GMT

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.

Re: How will I get values matching with the codes

Anonymous — Fri, 06 Nov 2015 13:05:53 GMT

Take 5 resident of it,

and Concatenate all with same name

Re: How will I get values matching with the codes

Anonymous — Fri, 06 Nov 2015 13:07:13 GMT

or at UI level in expression you can try:

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

same for values

Re: How will I get values matching with the codes

kavita25 — Fri, 06 Nov 2015 13:08:21 GMT

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

Re: How will I get values matching with the codes

Mark_Little — Fri, 06 Nov 2015 13:09:57 GMT

Something like this?

Data:

LOAD UNIT_CODE,

TRN_CODE,

TRN_REF_NO,

TRN_LINE_NO,

REF_NO,

REF_LINE_NO,

ITEM_CODE,

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

[..\..\Downloads\TRN_DET - Copy.xls]

(biff, embedded labels, table is [Sheet 1$]);

NoConcatenate

Sorted:

Load

1 as Type,

UNIT_CODE,

TRN_CODE,

TRN_REF_NO,

TRN_LINE_NO,

REF_NO,

REF_LINE_NO,

ITEM_CODE,

ITEM_REV_NO,

ITEM_DESC,

STORE_CODE_FROM,

STORE_CODE_TO,

ITEM_UOM,

ITEM_QTY,

CONV_UOM,

ITEM_CONV_QTY,

ITEM_RATE,

CAL_CODE1 as CAL_Code,

VALUE1 as Value

Resident Data;

Concatenate(Sorted)

Load

2 as Type,

UNIT_CODE,

TRN_CODE,

TRN_REF_NO,

TRN_LINE_NO,

REF_NO,

REF_LINE_NO,

ITEM_CODE,

ITEM_REV_NO,

ITEM_DESC,

STORE_CODE_FROM,

STORE_CODE_TO,

ITEM_UOM,

ITEM_QTY,

CONV_UOM,

ITEM_CONV_QTY,

ITEM_RATE,

CAL_CODE2 as CAL_Code,

VALUE2 as Value

Resident Data;

//Do for other values and cal codes.

Drop Table Data;

You can then use the type field to chose which value or cal_code you want to use.

Mark

Re: How will I get values matching with the codes

Anonymous — Fri, 06 Nov 2015 13:10:44 GMT

if you came to know any other solution, let me know

Re: How will I get values matching with the codes

settu_periasamy — Fri, 06 Nov 2015 13:26:25 GMT

May be try to use the for loop with concatenate..

For i = 1 to 40

If i=1 then

New:

Load 'CAL_CODE' $(i) as Flag,

YourFields

CALCODE1 as CAL_CODE,

VALUE1 as VALUE

Resident yourtable;

Else

Concatenate(New)

Load 'CAL_CODE' $(i) as Flag,

YourFields

CALCODE $(i) as CAL_CODE,

VALUE $(i) as VALUE

Resident yourtable;

Endif

Next i

Drop your resident table

Syntax may be incorrect. Sending via mobile..