QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for
Search instead for
Did you mean:
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
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".
11 Replies
Master II

Attached a version

Regards,
Taoufiq ZARRA

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

(you can mark up to 3 "solutions") 😉
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

Contributor III
Author

Hi Community,

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

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".
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

Contributor III
Author

Hi,

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

MVP

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

Contributor III
Author

Hi Kaushik,

Thank You for the solution.

Regards,

Nol

Contributor III
Author

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