topic Re: what should be expression / data model to merge two different calculation in single chart ? in QlikView

what should be expression / data model to merge two different calculation in single chart ?

shekhar_analyti — Wed, 25 Nov 2020 16:16:04 GMT

Hi All ,

what should be expression to merge two different calculation in single chart ?

I might be asking something trivial . But please help me to get a set expression with does below

I want below two separate to be merged

Something like

How to get it ?

Thanks & Regards

Shekar

Re: what should be expression / data model to merge two different calculation in single chart ?

shekhar_analyti — Wed, 12 Jun 2019 16:31:11 GMT

@sunny_talwar

Hi Sunny Bhai , in order to get above views i had made some changes with original data , and by doing so , i almost got similar structure but getting YOY calculation in the same chart with clear distinction is not happening for me .. Please suggest /help .

Attached raw data .

Re: what should be expression / data model to merge two different calculation in single chart ?

sunny_talwar — Wed, 12 Jun 2019 17:21:11 GMT

Check attached

Re: what should be expression / data model to merge two different calculation in single chart ?

shekhar_analyti — Thu, 13 Jun 2019 08:44:53 GMT

Thank You Sunny Bhai ..

Apart from using synthetic dimension , is there any way to solve this doing data model changes to original data .

Re: what should be expression / data model to merge two different calculation in single chart ?

sunny_talwar — Thu, 13 Jun 2019 11:11:12 GMT

By joining the result instead of keeping them as separate tables...

Re: what should be expression / data model to merge two different calculation in single chart ?

shekhar_analyti — Thu, 13 Jun 2019 12:18:51 GMT

Sunny Bhai .. Thanks for the Reply .

What i meant to ask was that , according your solution we have to create synthetic dimension (script level) and had to do sorting using only function (UI) .

But if i have to use only this - > sum(vlues) in expression tab , rest all to be done at script level , in order to get the exact view . What should be the script ?

Sorry , if i am trying to over complicate .

Re: what should be expression / data model to merge two different calculation in single chart ?

sunny_talwar — Thu, 13 Jun 2019 12:22:16 GMT

This will require some scripting. Unfortunately, I don't have the time to do this right now... may be someone else can check this out.

Re: what should be expression / data model to merge two different calculation in single chart ?

shekhar_analyti — Thu, 13 Jun 2019 12:32:42 GMT

I understand .

Many thanks for this and upcoming questions as well !