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
sunny_talwar

This is needed as a dimension or Expression? And are you trying to do it in a pivot table as a calculated dimension or in the script?

vikasmahajan
Author

Test qvw is attached please find and i want it in script

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.
MK_QSL
MVP
MVP

Mytab:

LOAD * INLINE

[

  Cat,Qty

    Planned, 1000

    Forcast,2000

    Planned, 3000

    Forcast,6000

];

Concatenate

Load * Inline

[

  Cat

  NEWCATEGORY

];

Use below expression..

IF(Cat = 'NEWCATEGORY', sum(TOTAL {<Cat = {'Planned'}>}Qty)-sum(TOTAL{<Cat = {'Forcast'}>}Qty),sum(Qty))

vikasmahajan
Author

Thanks Manish I will check and reply

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,

Suppose I have 2 more dimension below cat dimension like grp1,grp2 then result will come same ?

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

should I use aggr ?

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.
MK_QSL
MVP
MVP

Provide data.. I can't reply without checking !

vikasmahajan
Author

attached new qvw

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.
MK_QSL
MVP
MVP

Can I have the result also which you are looking for your new file?