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

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

paulyeo11 — Wed, 22 May 2013 06:18:01 GMT

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

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

paulyeo11 — Wed, 22 May 2013 06:22:13 GMT

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

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

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

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

jjordaan — Wed, 22 May 2013 06:38:00 GMT

Hi Paulyeo11,

Do you realy need to join?

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

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

gandalfgray — Wed, 22 May 2013 08:57:00 GMT

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

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

er_mohit — Wed, 22 May 2013 10:41:04 GMT

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

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

paulyeo11 — Wed, 22 May 2013 10:50:35 GMT

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.

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

paulyeo11 — Wed, 22 May 2013 10:52:35 GMT

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.

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

paulyeo11 — Wed, 22 May 2013 10:54:47 GMT

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.

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

er_mohit — Wed, 22 May 2013 11:53:13 GMT

try to use left keep or right keep which you want

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

jjordaan — Wed, 22 May 2013 12:01:32 GMT

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.

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

paulyeo11 — Wed, 22 May 2013 12:35:58 GMT

Hi All

Thank you very much for all your reply.

I manage to figure out , i make a mistake to run calendar script twice that cause a problem..

Paul.