Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
paulyeo11
Valued Contributor III

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
Highlighted
er_mohit
Honored Contributor II

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

try to use left keep or right keep which you want

View solution in original post

10 Replies
paulyeo11
Valued Contributor III

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

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

Highlighted
Partner
Partner

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

Hi Paulyeo11,

Do you realy need to join?

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

Highlighted
gandalfgray
Valued Contributor II

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

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

Highlighted
er_mohit
Honored Contributor II

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

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

Highlighted
paulyeo11
Valued Contributor III

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

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.

Highlighted
paulyeo11
Valued Contributor III

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

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.

Highlighted
paulyeo11
Valued Contributor III

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

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.

Highlighted
er_mohit
Honored Contributor II

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

try to use left keep or right keep which you want

View solution in original post

Highlighted
Partner
Partner

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

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.