Set Analysis - Intersection

[#1]

Hi All,

I am having a scenario where i am creating two sets SET1 and SET2 from a single table. I would like to perform set intersection on these two sets and i don end up in a result. The intersection does not happen.

I would also like to know some basics about how qlikview handles sets for intersection. Like Whether intersection can only be done on resident objects.

Should an intersection field be definitely used for joining two tables in the design..etc...

Any point regarding this will be more helful on this.

Can anyone help me on this.

Thanks

Hari

[#2]

Hi Kaushik,

Please find the image attached from the application. Here i could find both the zipcodes(100 and 201) in the Other_Zipcodes dimension. I think i am missing something. Please check.

Thanks

Hari

[kaushiknsolanki]

Hi,

   I think due to the file i have uploaded had same name and you have download at the same loacation it is not updated..

   In the file i recetly uploaded you can see the full table where you can see the 1 to 20 only within table only.

  Here is the another file.

Regards,

Kaushik Solanki

[#4]

Hi Kaushik,

I am really sorry abt this. I jus downloaded the appln in a seperate location and accessed it. But could see both the zipcodes there. Can you please provide me a screenshot of the appln and tha ppln itself with a diff name. I will check here where I am going wrong.

Thanks

Hari

[kaushiknsolanki]

Hi,

   Here is the screenshot of that.

Regards,

Kaushik Solanki

[#6]

Hi kaushik,

Nice i could see what i am looking for , but i am not able to get this from the application . Could not guess the reason. Can you please rename the appln and post it here. Thanks for this.

Thanks

Hari

[kaushiknsolanki]

HI,

   Gr8 finally u got what you wanted.

   Here is your Application with diff name.

Rergards,

Kaushik Solanki

[#8]

Hi Kaushik,

Thanks a lot for your responses.

I am using Qlikview 8.5 version and i think that was the reason, why the P() does not work in mine. Please let me know your version of Qlikview and also if there is any other way of getting the intersection results.

Thanks

Hari

[kaushiknsolanki]

Hi,

   Yes may be that can be a reason.

   I am using qlikview v10 SR 2.

   I dont know. i have to try to get this without p().

   Will post as soon as i get solution.

Regards,

Kaushik Solanki

[johnw]

Perhaps this:

count({Book1} Other_Zipcodes)>0 and count({Book2} Other_Zipcodes)>0

[#11]

Hi John,

Thanks for this.

I tried with the expression. It works fine when i don use any filters in my expression when creating the bookmarks. If i have any filter condition in creating my bookmark then this does not work. Please let me know on this.

Thanks

Hari