Logic Help Required

[abhaysingh]

Hi all,

i have one code lets say LH which contain Sales Value.

and i have targets available against that code but in Bifurcated way like LF-europe(55% of total sales) and LH A++(45% total sales)

how i can map it against singal code LH.

Thanks to all

regards

Abhay

[avinashelite]

can you please provide the sample data, so that we can understand the problem

[datanibbler]

Hi Abhay,

I'm not quite clear about what you mean. Is there one Sales_value that is supposed to be measured against two targets simultaneously? Or do you have to split up the Sales_value and then compare part_A to target_A and part_B to target_B?

Best regards,

DataNibbler

[abhaysingh]

Hey Guys,

i have one sales value against one code LH let say 1000

and against LH code two Targets available in Percentage lets say A (which is 55% of Total Sales) and B(Which is 45% of Total Sales).

Now when i select Code LH, both actual should be split into Actual A and Actual B and target should map against both.

hope it will help u guys to understand.

thanks

[abhaysingh]

Hi Nibbler,

you r right with your below ques

I'm not quite clear about what you mean. Is there one Sales_value that is supposed to be measured against two targets simultaneously?

[avinashelite]

Hi Abhay,

We got your point, if you have key associated with it Qlikview will automatically load that data rite??

can you share the sample data, that would be more useful for us to understand

[nagarjuna_kotha]

Hi Abhay,

Can u Provide Source template for better understanding.

Regards,

Nagarjuna

[abhaysingh]

Sry Avinash, would not possible to share confidential data.

[abhaysingh]

kindly revert

[avinashelite]

Hi abhay,

No need share the exact data my friend, just create a dump data set and show us in table and results what your excepting so that we can visualize it