Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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:

Requirement.png

@sunny_talwar 

 

Regards,

RD

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
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
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

11 Replies
Highlighted
Specialist II
Specialist II

Re: Set Analysis Logic

Attached a version

 

Capture.PNG

Regards,
Taoufiq ZARRA
Highlighted
Contributor III
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
Contributor III

Re: Set Analysis Logic

Hi Community,

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

@sunny_talwar 

Highlighted
MVP & Luminary
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
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Highlighted
Contributor III
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
Contributor III

Re: Set Analysis Logic

Hi,

 

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

Highlighted

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
Contributor III

Re: Set Analysis Logic

Hi Kaushik,

Thank You for the solution.

 

Regards,

Nol

Highlighted
Contributor III
Contributor III

Re: Set Analysis Logic

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