topic Re: Conditional load in qlikview in QlikView

Conditional load in qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Conditional load in qlikview

adamdavi3s — Wed, 03 Aug 2016 08:43:36 GMT

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?

Re: Conditional load in qlikview

Mark_Little — Wed, 03 Aug 2016 08:52:41 GMT

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

Re: Conditional load in qlikview

Wed, 03 Aug 2016 09:10:53 GMT

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

Re: Conditional load in qlikview

avinashelite — Wed, 03 Aug 2016 09:13:46 GMT

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

Re: Conditional load in qlikview

sunny_talwar — Wed, 03 Aug 2016 09:35:07 GMT

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?

Re: Conditional load in qlikview

Wed, 03 Aug 2016 09:57:59 GMT

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

Re: Conditional load in qlikview

Wed, 03 Aug 2016 11:44:06 GMT

Hi Megha,

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

Regards

Tripati

Re: Conditional load in qlikview

Thu, 04 Aug 2016 14:39:16 GMT

Hi Sunny

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

Regards

Tripati