Discussion Board for collaboration related to QlikView App Development.
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 ?
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,
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
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
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.
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.
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.