Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

loading qvd and joining

I have an excel file Budget that has a DATE,CATEGORY in it that can be used for joining.

My other two tables HSHED has a DATE in it.  HSDET had in detail information for HSHED but doesn't have a DATE in the file but does have my CATEGORY in it.

I need to join The Budget file that  has a record of every work day.  I need to get by CATEGORY for each workday the $ Sales.

I can join the HSHED by DATE to the BUDGET file.

My problem is since there isn't a DATE in HSDET how do I get the CATEGORY to match up.

Normally in other applications I would read the HSHED and HSDET because they join together and get the DATE and $ Sales then I would join that to the BUDGET by DATE and CATEGORY.

I just don't know howw to do this in Qlikview.


0 Replies