Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RD_Nol
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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

11 Replies
Taoufiq_Zarra

Attached a version

 

Capture.PNG

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
RD_Nol
Contributor III
Contributor III
Author

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

Hi Community,

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

@sunny_talwar 

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
RD_Nol
Contributor III
Contributor III
Author

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

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

Hi Kaushik,

Thank You for the solution.

 

Regards,

Nol

RD_Nol
Contributor III
Contributor III
Author

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