topic Re: how can I write if statement on the script for the below data in QlikView

how can I write if statement on the script for the below data

Sarath123 — Tue, 10 Sep 2019 12:55:36 GMT

Hello,
I have the data as shown below
code Total sales company sales
1101 140000 10000
11010 200000 50000
11020 1000000 90000

My requirement was to compute company sales per code.
Suppose for code(1101) the cmpny sales are 10000
But I have another condition
for the code(11010) the sales should calculated as companysales[code(11010)] - companysales[code(11020)]

I cannot find a way to define that on the script?
Any suggestions!

Re: how can I write if statement on the script for the below data

StarinieriG — Tue, 10 Sep 2019 13:17:59 GMT

Hi,

something like this? File attached

Re: how can I write if statement on the script for the below data

Sarath123 — Tue, 10 Sep 2019 13:52:33 GMT

Thank you 😊
It worked