Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
Luminary Alumni
Luminary Alumni

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
Taoufiq_Zarra
Master II
Master II

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
Luminary Alumni
Luminary Alumni

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

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.