Calculate ODD

johnan — Thu, 05 Nov 2020 17:23:44 GMT

Hi, got 2 tables

Table 1: This conatains just ordernumber, articles and quantity on order
Table 2: This contains article data type, length, hight, wieght and casepack

I want in my script identify all rows from table 1 that not equal to the case pack, let me illustrate:

From table 1:
1.Ordernumber 455, article 12222, quantity 3
2.Ordernumber 455, article 12222, quantity 6
-----------------------------------------------------------------
Table 2 contains
Article 455, Casepack 6

-----------------------------------------------------------------

So now in my script a will mark row 1 with 'ODD' and row 2 with 'EVEN'

Are you with me 🙂

Re: Calculate ODD

MayilVahanan — Fri, 06 Nov 2020 01:18:13 GMT

Hi @johnan

T1:

Load * from Table1;

Join(T1)

Load Article, Cashpack from Table2;

Load *, if(Cashpack = Quantity, 'Even', 'Odd') resident T1;

Drop table T1;

Hope it helps.

topic Re: Calculate ODD in QlikView

Calculate ODD

Re: Calculate ODD