Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
PMF
Contributor II
Contributor II

Pivot Table Trick

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

Capture.PNG

 

Labels (1)
14 Replies
PMF
Contributor II
Contributor II
Author

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:

Capture2.PNG

I use w10 and 64 bit Qlikview.

Would you know what the problem could be?

 

Thanks and Regards

Peter

Anil_Babu_Samineni

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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
PMF
Contributor II
Contributor II
Author

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

PMF
Contributor II
Contributor II
Author

Can you share the script or provide some guidance?

Thanks

Peter

 

Anil_Babu_Samineni

What script you are experiencing?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful