Join should work only when it a drop down is selected in list box

[#1]

Hi Team,

I have an requirement where I should use joins but the join should  work perfectly when a option is used.

Without Selecting  any filter I should get the below result for Jan 14 month

Date     ID Count           Hp Count

Jan 14    4                      2

I am only getting the result when I am selecting both Date and Country filter.

For your reference I am attaching sample qvw file.

Thanks in Advance...

Sreehari Satheesan

[Anonymous]

You have duplicated records because of the joins. Try to keep the tables separate. You should use joins on fact table if you are sure that

there the table you are joining has 1-1 (distinct) values and keep it  separate if that's not the case. Please see the attached file.

Thanks,

[#3]

Thanks for your proposed solution solution.

Just to confirm you since I don't have unique key between the tables will this linking between the tables will work for the duplicates entries too.

[Anonymous · Accepted solution]

Sorry not clear what you meant by duplicate entries.

You do not have duplicate entries in your source tables, you had duplicate entries in your final table as a result of the joins. Simply you can't use joins (for combing all these tables into one single table) in your case so keep them separate and link them using the keys and it should be fine. Please click answered if it solves your problem.

Thanks,