Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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