# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

## Set Analysis Logic

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:

Regards,

RD

Labels (1)
• ### Set Analisys

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary

## Re: Set Analysis Logic

Hi,

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

Regards,
Kaushik
11 Replies
Highlighted
Specialist II

## Re: Set Analysis Logic

Attached a version

Regards,
Taoufiq ZARRA
Highlighted
Contributor III

## Re: Set Analysis Logic

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

Highlighted
Contributor III

## Re: Set Analysis Logic

Hi Community,

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

Highlighted
MVP & Luminary

## Re: Set Analysis Logic

Hi,

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

Regards,
Kaushik
Highlighted
Contributor III

## Re: Set Analysis Logic

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

Highlighted
Contributor III

## Re: Set Analysis Logic

Hi,

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

Highlighted
MVP

## Re: Set Analysis Logic

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

Highlighted
Contributor III

## Re: Set Analysis Logic

Hi Kaushik,

Thank You for the solution.

Regards,

Nol

Highlighted
Contributor III

## Re: Set Analysis Logic

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