Set Analysis Logic

[RD_Nol]

Hi Community,

I've attached the Qlikview file & Sample excel.  I've posted the requirement in the .qvw

Need Set Analysis Solution. I'm not able to apply the logic. Please check the attachment & provide me the solution.

PFB the requirement:

@sunny_talwar 

Regards,

RD

[Taoufiq_Zarra]

Attached a version

[RD_Nol]

Hi,

Thanks for the reply but there are n number of countries and n number of products.

So, this is would not be the right approach. I'm trying to achieve this through P() function.

Regards,

RD

[RD_Nol]

Hi Community,

Can anyone help me in find the solution. I'm in real need.

@sunny_talwar 

[kaushiknsolanki · Accepted solution]

Hi,

You will need to modify the script a little. Check the solution provided in the attached qvw file.

[RD_Nol]

Hi Sir,

Thanks for the reply. I like the approach though. It's a new learning for me.

But Sir, I need to do this at front end. Can we do that using Set analysis something P() function.

Regards,

Nol

[RD_Nol]

Hi,

I want to solve this scenario using Only & Possible P() function

[sunny_talwar]

I don't think it is doable just by using set analysis. What @kaushiknsolanki provided is probably the best solution for this problem

[RD_Nol]

Hi Kaushik,

Thank You for the solution.

Regards,

Nol

[RD_Nol]

Thank You Sunny Sir. I implemented the same solution for my code.