topic Re: Problems in script in QlikView

Problems in script

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

Hello guys i have facing a problem in script level.

i want to pick value in row using condition. please see my attach file.

i have two filed which name one is opening quantity and one is closing quantity

i will create a calculated filed which name is NewOpqty.

please see my image file and also see my script if you have any idea then please share with me.

i need this condition if(opening quantity<>0 ,opening quantity,peek(opening quantity)) and also need this condition

if closing quantity<>0 then peek(closing quantity) or opening quantity.

But some how my condition will not working.

Thanks in advance

Swarnendu.

Re: Problems in script

Anil_Babu_Samineni — Wed, 03 Jan 2018 11:46:31 GMT

Not sure, I understand your concern. Can you please share sample?

Re: Problems in script

swarnendu — Wed, 03 Jan 2018 11:52:17 GMT

Please check my .qvw file

Re: Problems in script

Anil_Babu_Samineni — Wed, 03 Jan 2018 12:26:18 GMT

Which table we need to look?

Re: Problems in script

swarnendu — Wed, 03 Jan 2018 12:31:15 GMT

The table name is Final_Stock

Re: Problems in script

swarnendu — Wed, 03 Jan 2018 12:33:00 GMT

I used this condition ....

if( New_MasterCode <> Peek(New_MasterCode) , If( MasterCode <> Peek(MasterCode), IF( Opening_Qty <> 0 ,Opening_Qty , Peek(NewOpQty) ) ), If(Opening_Qty = 0 ,Peek(Closing_Qty) , Opening_Qty) ) as NewOpQty,

but its not working

Re: Problems in script

Anil_Babu_Samineni — Wed, 03 Jan 2018 12:48:59 GMT

That means, You are going to call 2 if..else statement using single IF statement? Isn't it?

Re: Problems in script

swarnendu — Wed, 03 Jan 2018 12:55:54 GMT

Brother i want a new column which is depends on opening qty and closing qty.

i have opening for each new master code which have only one date.

i just need if opening quantity is 0 then its peek opening quantity depend on closing quantity if closing quantity has value then opening is show me the closing value.

Re: Problems in script

swarnendu — Wed, 03 Jan 2018 13:01:12 GMT

just check in master code='2793' and new master code =' 7268'

and check the filed NewOpQty.

i just want to remove the 0 values with 3.16 till 5.16

Re: Problems in script

sunny_talwar — Wed, 03 Jan 2018 13:32:46 GMT

You complete logic seems to be not right... can you put it in words what this is suppose to do?

Re: Problems in script

Anil_Babu_Samineni — Wed, 03 Jan 2018 14:24:46 GMT

To remove all zero rows you could use Len(Calculation)>0 as FieldName, ......

Re: Problems in script

swarnendu — Thu, 04 Jan 2018 06:13:39 GMT

Hi Sunil,

I have two field 1 have only opening quantity but its have no date thats why i already doing generate date till as on date.

i have also another field which name is closing quantity which have full transaction date i want to marge both field and create a another field which name is newopqty .

just i need like i have first opening quantity so its show me first date opening quantity then its check next row

if next is zero and closing <>0 then next row peek closing quantity otherwise its peek only opening quantity in next row