topic Re: Join should work only when it a drop down is selected in list box in QlikView

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

Tue, 07 Apr 2015 00:36:44 GMT

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

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

Anonymous — Tue, 07 Apr 2015 00:59:41 GMT

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,

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

Tue, 07 Apr 2015 01:15:34 GMT

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.

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

Anonymous — Tue, 07 Apr 2015 20:48:32 GMT

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,