Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

I have GL Table after i add sales table my curreny variable give wrong value

Hi All

I have a data model , which is GL Table , and in order for me to provide more information to the GL Table , i add the sales Table , so that user are able drill in and get more information on sales from which customer.

After i add the sales table , i am not able to make use of my currency rate variable , as it does not work. it give wrong rate. Hope some one can share with me how to solve this ?

Paul

1 Solution

Accepted Solutions
er_mohit
Master II
Master II

try to use left keep or right keep which you want

View solution in original post

10 Replies
paulyeo11
Master
Master
Author

To provide you more info , i enclosed below the data model before add sales table work fine one currency variable.

before i add sales table.png

Below image shown after i add sales table , my currency rate not working :-

sales table inside gl table.png

My issue is the may be due to i join wrongly , i should make the sales table inside GL table.

Hope some one can share with me how to join,

Paul

jjordaan
Partner
Partner

Hi Paulyeo11,

Do you realy need to join?

Can't you concatenate the sales table into the GL table?

gandalfgray
Specialist II
Specialist II

I think you may leave sales_table as a linked table,

but I suggest you replace "date" with "sales_date"  to break the circular reference

(use  date As sales_date

in your load statement)

Then you should probably have a separate salescalendar table linked to sales_table via sales_date

/gg

er_mohit
Master II
Master II

Try to use left join if your Gl_Table has more Gl_Code which are exists in sales_Table

So, for this you use Left join

if don't know try to use only join then your Sales_Table into Gl_Table.

hope it helps

paulyeo11
Master
Master
Author

Hi Jeroen

I can not concatenate . Because both table field are different and I have 5 diff sales table and GL Table from diff country.

Any way thank you for yr reply.

paulyeo11
Master
Master
Author

Hi Gan

I have already try what you mentioned on all the point. But I still cannot figure out why after add sales table it affect my vCurrency variable.

Thank you for yr advise.

paulyeo11
Master
Master
Author

Hi eR

Thank you for yr suggestions.

I try left john csnnot work because it will make my file become very big.

Link should be right. But it affect my var on exchange rate.

er_mohit
Master II
Master II

try to use left keep or right keep which you want

View solution in original post

jjordaan
Partner
Partner

PaulYeo11,

What er.mohit is telling is also a possibilty.

I would use the Where exists functionality because that's beter from a performance point of view.