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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan

How to arrive new dimension using already loaded dimension

Hii

I have  following data

Actual  & Plan dimension and units and values in pivot , now I want to arrive dimesion c = Plan - actual

how to arrive.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
11 Replies
vikasmahajan
Author

Result -4000 is correct as per your script but when I apply in production environment result is appear!

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
vikasmahajan
Author

Hii

Manish,

Attached exact data with my requirement is show NEWCAT as  forcast - plan in dimension.

Please give suggestion.

Thanks

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.