topic Re: nested if in QlikView

nested if

dzhanito — Fri, 05 Aug 2022 11:31:16 GMT

This code must not apply to certain items so they can pick them up without *1.2 Sum({< [Item No_] = {"=[Item No_] = [Item No_]"} >} [Unit Price]*1.2) here are the codes from Item No. which should normally be taken without *1.2

12974,14584,14573,4236,4237,4238,4241,4242,4243,4244,4247,7430,8114,12126,16009,16010,15284,4249,4256,4258,12973,14739,7365,4259,8970,10608,12338,12339,12373,17015,12545,13484,16076,16078,16123,16788

like is script error:=if(Sum({< [Item No_] = {"=12974,14584,14573,4236,4237,4238,4241,4242,4243,4244,4247,7430,8114,12126,16009,16010,15284,4249,4256,4258,12973,14739,7365,4259,8970,10608,12338,12339,12373,17015,12545,13484,16076,16078,16123,16788 =[Item No_]"} >} [Unit Price]),Sum({< [Item No_] = {"=[Item No_] = [Item No_]"} >} [Unit Price]*1.2))

Re: nested if

dzhanito — Fri, 05 Aug 2022 12:05:40 GMT

this is how the formula works for me but only for one item and to include more than one how to write the code

=if([Item No_] =4236 , [Unit Price],Sum({< [Item No_] = {"=[Item No_] = [Item No_]"} >} [Unit Price]*1.2))

Re: nested if

marcus_sommer — Fri, 05 Aug 2022 14:37:35 GMT

I'm not sure if I understand your aim right but I assume you want in the end something like this:

rangesum(sum({< Item = {1, 2, 3}>} Price * 1.2), sum({< Item -= {1, 2, 3}>} Price))

which will sum the price from certain items * factor and all others without the factor and both parts are parameters within a rangesum().

- Marcus

Re: nested if

dzhanito — Mon, 08 Aug 2022 06:51:52 GMT

works thanks a lot 🙂