Conditional load in qlikview

[#1]

Hi all,

I want to show data based on condition.

I have attached screenshot for the same.My condition is sum(Quantity)>=Quantity on hand

In my first screenshot I have selected one product number

Here sum(Quantity) is 12 which is less then Quantity on hand ie 24.

So my output is like Screenshot2.

I want to show currently loaded Product number so that the  condition is sum(Quantity)>=Quantity on hand should match.

Please help me and let me know any further input want form my side.

Regards

Tripati

[adamdavi3s]

Can you upload your document, It isn't clear exactly what you are trying to do.

Can you explain exactly what the output you are expecting is?

[Mark_Little]

HI,

yer some details would be helpful as i am not sure what you want to show.

Is it only show product where the Quantity >= Quantity on hand

if so then

If(SUM(Quantity) >= SUM([Quantity on Hand]), SUM(Quantity))

If not more info please

Mark

[#4]

Please check attahced QVW. not sure if you are asking for the attached result.

it will show the data for Product Num for which sum(Qauntity on hand)<=sum(Quantity). !

[avinashelite]

Could please provide more info ? like the data you have the output your excepting ??

[sunny_talwar]

In you example, is quantity on hand is 24 or 3? I think the output is showing 3 because the quantity on hand is 3 and you can only meet the demand for first three request. Is that what the logic is?

[#7]

Hi Sunny,

Thanks for your reply.

Quantity on hand is 3.

My required output is load the product number where sum(quantity)>=quantity on hand.

You can see in my exemple, in screen shot1 8 times Product numbers displaying

but my requirement is to show only that latest loaded product number  where the condition is  sum(quantity)>=quantity on hand is match.

Here I am showing Product number  1031092 3times because sum(QUANTITY) is 3>=quantity on hand  is 3

Thanks and regards

Tripati

[#8]

Hi Megha,

Not able to open file because of personal edition ,can you please share script.

Regards

Tripati

[#9]

Hi Sunny

Please let me know any more information you want my side.

Regards

Tripati