topic How to arrive new dimension using already loaded dimension in QlikView

How to arrive new dimension using already loaded dimension

vikasmahajan — Wed, 12 Aug 2015 10:14:26 GMT

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

Re: How to arrive new dimension using already loaded dimension

sunny_talwar — Wed, 12 Aug 2015 10:17:58 GMT

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?

Re: How to arrive new dimension using already loaded dimension

vikasmahajan — Wed, 12 Aug 2015 10:27:47 GMT

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

Vikas

Re: How to arrive new dimension using already loaded dimension

MK_QSL — Wed, 12 Aug 2015 10:29:16 GMT

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))

Re: How to arrive new dimension using already loaded dimension

vikasmahajan — Wed, 12 Aug 2015 10:33:57 GMT

Thanks Manish I will check and reply

Vikas

Re: How to arrive new dimension using already loaded dimension

vikasmahajan — Wed, 12 Aug 2015 11:01:01 GMT

Hii,

Manish,

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

Vikas

Re: How to arrive new dimension using already loaded dimension

vikasmahajan — Wed, 12 Aug 2015 11:01:32 GMT

should I use aggr ?

Re: How to arrive new dimension using already loaded dimension

MK_QSL — Wed, 12 Aug 2015 11:03:16 GMT

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

Re: How to arrive new dimension using already loaded dimension

vikasmahajan — Wed, 12 Aug 2015 11:11:43 GMT

attached new qvw

Re: How to arrive new dimension using already loaded dimension

MK_QSL — Wed, 12 Aug 2015 11:15:20 GMT

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

Re: How to arrive new dimension using already loaded dimension

vikasmahajan — Wed, 12 Aug 2015 11:18:32 GMT

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

Vikas

Re: How to arrive new dimension using already loaded dimension

vikasmahajan — Thu, 13 Aug 2015 05:24:32 GMT

Hii

Manish,

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

Please give suggestion.

Thanks

Vikas