topic Re: Set Analysis Logic in QlikView

Set Analysis Logic

RD_Nol — Sat, 16 Nov 2024 00:54:20 GMT

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:

@sunny_talwar

Regards,

Re: Set Analysis Logic

Taoufiq_Zarra — Fri, 03 Apr 2020 17:24:35 GMT

Attached a version

Re: Set Analysis Logic

RD_Nol — Fri, 03 Apr 2020 17:47:52 GMT

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,

Re: Set Analysis Logic

RD_Nol — Sat, 04 Apr 2020 17:59:12 GMT

Hi Community,

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

@sunny_talwar

Re: Set Analysis Logic

kaushiknsolanki — Sat, 04 Apr 2020 18:37:11 GMT

Hi,

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

Re: Set Analysis Logic

RD_Nol — Sat, 04 Apr 2020 22:07:54 GMT

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

Re: Set Analysis Logic

RD_Nol — Sun, 05 Apr 2020 19:08:35 GMT

Hi,

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

Re: Set Analysis Logic

sunny_talwar — Mon, 06 Apr 2020 13:13:42 GMT

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

Re: Set Analysis Logic

RD_Nol — Thu, 09 Apr 2020 17:45:32 GMT

Hi Kaushik,

Thank You for the solution.

Regards,

Nol

Re: Set Analysis Logic

RD_Nol — Thu, 09 Apr 2020 17:46:30 GMT

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

Re: Set Analysis Logic

kaushiknsolanki — Thu, 09 Apr 2020 17:46:40 GMT

My Pleasure.

Cheers. 🙂

Re: Set Analysis Logic

sunny_talwar — Thu, 09 Apr 2020 19:01:12 GMT

Call me Sunny please. I am as much a learner as you are.