How to arrive new dimension using already loaded ... - Qlik Community

vikasmahajan · ‎2015-08-12

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.

sunny_talwar · ‎2015-08-12

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 · ‎2015-08-12

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 · ‎2015-08-12

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 · ‎2015-08-12

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 · ‎2015-08-12

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 · ‎2015-08-12

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 · ‎2015-08-12

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

vikasmahajan · ‎2015-08-12

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 · ‎2015-08-12

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

How to arrive new dimension using already loaded dimension