Discussion Board for collaboration related to QlikView App Development.
I'm having the below 2 tables, Dimsales coming from Excel and Facts_L1 coming from DB.
The association between the 2 tables is maintained using Sales_RepKey.
But, somehow the association doesn't seems to be proper. If I'm selecting some value on Excel field, it's not showing the proper associated value from DB.
I want both the fileds to be associated properly.
I want the association in such a way that if i select Australia from Cluster(DB), it should associate to Australia in Dimsales_Cluster(Excel).
The script used is as follows:
UPPER(DimSales_Date &'-'& DimSales_Person_Email) as Sales_RepKey,
Left Join (DimSales)
UPPER(MonthName(Date)&'-'& Sales_Person_Email) as Sales_RepKey
where Date >= '01/01/2015';
Could someone please do the needful.
Thanking in Advance.
can you share some sample data
Can you check whether thw value /format in your joining key ia same or not ?
On Sun, Jun 3, 2018, 11:56 PM Jeshwanth Boragani <firstname.lastname@example.org>
The value/format in my joining key is same.
Thanks & Regards,
ok,Can you please share qvw so that I can look into it?