topic Re: Logic Help Required in QlikView

Logic Help Required

abhaysingh — Tue, 07 Apr 2015 07:05:13 GMT

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

Re: Logic Help Required

avinashelite — Tue, 07 Apr 2015 07:10:34 GMT

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

Re: Logic Help Required

datanibbler — Tue, 07 Apr 2015 07:12:37 GMT

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

Re: Logic Help Required

abhaysingh — Tue, 07 Apr 2015 07:17:06 GMT

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

Re: Logic Help Required

abhaysingh — Tue, 07 Apr 2015 07:18:16 GMT

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?

Re: Logic Help Required

avinashelite — Tue, 07 Apr 2015 07:22:05 GMT

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

Re: Logic Help Required

nagarjuna_kotha — Tue, 07 Apr 2015 07:23:22 GMT

Hi Abhay,

Can u Provide Source template for better understanding.

Regards,

Nagarjuna

Re: Logic Help Required

abhaysingh — Tue, 07 Apr 2015 07:48:12 GMT

Sry Avinash, would not possible to share confidential data.

Re: Logic Help Required

abhaysingh — Tue, 07 Apr 2015 09:28:29 GMT

kindly revert

Re: Logic Help Required

avinashelite — Tue, 07 Apr 2015 09:49:36 GMT

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

Re: Logic Help Required

avinashelite — Tue, 07 Apr 2015 09:57:49 GMT

as per my understanding,

table1:

1000

table2:

key,Product, %,Actual Amount

1000,A, 56%,10000

1000,B, 44%,10000

your result should be like:

Product, Amount

A,5600

B,4400

if this is what you wanted then, try like below:

Load Key,

Product,

(%*Actual Amount)/100 as new_amount;

this should solve the issue

Re: Logic Help Required

abhaysingh — Tue, 07 Apr 2015 09:59:19 GMT

OK DEAR, i'll try to do and share wid u

Re: Logic Help Required

abhaysingh — Tue, 07 Apr 2015 10:08:29 GMT

hi Avinash,

u r right but i have hundreds of value in a Code Field and LH is one of that for which i have to bifurcate sales value into percentage and for rest it should be 100%.

Re: Logic Help Required

abhaysingh — Tue, 14 Apr 2015 07:39:46 GMT

its done thanks all of you for help...