Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

Possible to make both SOURCE field name same for sales table and inventory table ?

Hi All

I have a sales table with all field like company , invoice date , stock code , selling price , costing price , date of transaction and Source_sales field for group by country.

I also have a inventory table . Which also have stock code field , Qty on hand , Amount on hand and Source_stock field for group by country.

I have create a link key between both table , using stock code and Source_sales for sales table.

I also create a link key for Inventory table , using stock code and Source_stock , both link field are same.

Now the above is running fine. But the issue is Source_sales and Source_stock this field name are different.

I like to make the above field name dames.

Can some one advise me how ?

Paul

6 Replies

Re: Possible to make both SOURCE field name same for sales table and inventory table ?

can you please share your app ?

jaaldurgam
Valued Contributor

Re: Possible to make both SOURCE field name same for sales table and inventory table ?

Hi Paul,

Qualify and Unqualify statements will be helpful to keep your field name same or different based on the requirement.

HTH

Sreeni

MVP & Luminary
MVP & Luminary

Re: Possible to make both SOURCE field name same for sales table and inventory table ?

Hi Paul,

While loading just rename Source_sales  and Source_stock as Source, so that this fields will be joined.

Regards,

Jagan.

paulyeo11
Valued Contributor II

Re: Possible to make both SOURCE field name same for sales table and inventory table ?

Hi Jagan

I will try your suggestion.

Paul

Sent from my iPhone

paulyeo11
Valued Contributor II

Re: Possible to make both SOURCE field name same for sales table and inventory table ?

Hi Jagan

I change the below script :-

'TDSS' as SOURCE_STK,

To below :-

'TDSS' as SOURCE,

when i reload the script , it hung :-

source_stk.png

paulyeo11
Valued Contributor II

Re: Possible to make both SOURCE field name same for sales table and inventory table ?

Hi Avinash

My issue is , for below field name :-

'TDSS' as SOURCE_STK,

I wish i can change to :-

'TDSS' as SOURCE,

Paul

Community Browser