topic Re: Pivot Table Trick in QlikView

Pivot Table Trick

PMF — Sat, 16 Nov 2024 17:39:25 GMT

Happy New Year to everyone!

I am new to this forum, and I hope you can help me with solving one problem.

We have a simple table containing positions across two dates, and a Pivot table with a fixed layout that compares those positions.
I am wondering if it's possible to add columns that display differences for each item between the dates (red arrows in the dummy table below).

Thank you in advance,
Best Regards
Peter

Re: Pivot Table Trick

Anil_Babu_Samineni — Mon, 04 Jan 2021 13:34:17 GMT

That is possible, If i understand correctly. Can you please share sample and expected outcome as in sketch?

Re: Pivot Table Trick

PMF — Mon, 04 Jan 2021 18:01:16 GMT

Hello Anil,

Thank you for your offer. I enclose two files, this is just atoy example.

Best Regards

Peter

Re: Pivot Table Trick

Anil_Babu_Samineni — Mon, 04 Jan 2021 18:08:58 GMT

Expected result? at least for 1 or 2 rows ?

Re: Pivot Table Trick

edwin — Mon, 04 Jan 2021 18:40:25 GMT

one way is to calculate the sum of the two fields in script, create a new field that defines which of the value fields it is: Val2, Val3 and the sum.

check out the attached

Re: Pivot Table Trick

PMF — Mon, 04 Jan 2021 20:40:48 GMT

Assuming addition operations 4+4=8 for val2, and 6+6=12 for val 3.

8+8=16, and 12+12=25 for the next row accrdingly.

Thank you so much!

Regards

Peter

Re: Pivot Table Trick

PMF — Mon, 04 Jan 2021 20:58:11 GMT

Hello Edwin,
Thank you so much for your solution. Please correct me if I am wrong, but I think I tried to do exactly that in the last section of the pivot table's screenshot that I included in my original post.
I should have start with explaining the bigger picture as well, my bad. The bigger picture is to use multiple variables (say ~15), large and relatively complex data sets extracted from DB and use those in risk analytics.
As you can imagine complexity in this setup goes quite quickly up.
Where I'd like to stick those results is exactly where those red arrows point out.

Thanks and Regards
Peter

Re: Pivot Table Trick

Anil_Babu_Samineni — Mon, 04 Jan 2021 21:03:04 GMT

Let me understand more, You mean like this?

Re: Pivot Table Trick

PMF — Mon, 04 Jan 2021 23:18:06 GMT

This is exactly it!!!

All the surce data will come from a SQL database, the structre will be much complex.

Thank you so much!

Peter

Re: Pivot Table Trick

Anil_Babu_Samineni — Tue, 05 Jan 2021 11:04:25 GMT

That won't be a problem, Even if it is compex it has some capable to do. PFA

Re: Pivot Table Trick

PMF — Tue, 05 Jan 2021 23:17:02 GMT

Hello Anil,

Thank you for looking into this. I have some problem with openingmthe doc, and I am unsue what's causing it.

The message I am getting is:

I use w10 and 64 bit Qlikview.

Would you know what the problem could be?

Thanks and Regards

Peter

Re: Pivot Table Trick

Anil_Babu_Samineni — Wed, 06 Jan 2021 08:44:02 GMT

There might be many cases, but few of them can given hint

- May be you are using app who created else or using some license and now license no more valid

- App may deleted or corrupted?

Re: Pivot Table Trick

PMF — Wed, 06 Jan 2021 23:00:51 GMT

Hello,

The file I publihed ia a training file with desktop license (free) for training purpose only. The one that I use at work is fully licensed.

I downloaded and tried to open your file few times with the same result.

Is there anything ese that can cause a problem here?

Thanks and Regards

Peter

Re: Pivot Table Trick

PMF — Fri, 08 Jan 2021 01:15:36 GMT

Can you share the script or provide some guidance?

Thanks

Peter

Re: Pivot Table Trick

Anil_Babu_Samineni — Fri, 08 Jan 2021 18:25:21 GMT

What script you are experiencing?