Join should only work when an option 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 selected in list box(Filter)

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

[ramoncova06]

can you elaborate more on your requirement, what do you mean by join ?

I am assuming this might something related with how the data associated with each other

[#3]

Hi ,

Thanks for your reply..

Yes correct .. I have to use the same data model which I have implemented by joining the first two tables with left join and next table with right join.

Then only I will get the desired output when I use the both the filters.

Sreehari Satheesan

[ramoncova06]

Qlikview does not work that way, once you apply a join thru the script all that data is added into one single table

you might want to do this without applying  any join into the data and allow qlikview to do the association based on the field names