How to avoid select <6 Mth and not turn on Fast Moving ?

paulyeo11 — Fri, 22 Dec 2017 01:18:58 GMT

Hi All

I have expression below from Anil. it work fine . But due to <6 Mth and Fast moving product both are link.

if(L_issue = '00/00/0000' AND L_move <> '00/00/0000', ('New Product'),

if(S1 > '0' AND S2 > '0' and S3 > '0', ('Fast Moving'),

If([No of Months_] >= 1 and [No of Months_] <= 6, Dual('<6 Mth', 1),

If([No of Months_] >= 7 and [No of Months_] <= 12, Dual('>6 Mth-1 Yr', 2),

If([No of Months_] >= 13 and [No of Months_] <= 36, Dual('>2-3 Yr', 3),

If([No of Months_] >= 37 and [No of Months_] <= 60, Dual('>3-4 Yr', 4),

If([No of Months_] >= 61 and [No of Months_] <= 84, Dual('>4-5 Yr', 6),

If([No of Months_] >= 85 , Dual('>5 Yr', 7),

))))))))

Because when items for keep selling for last 3 month i classify it as fast moving , and for stock less then 6 month in ware house , which may consider as fast moving.

So my question is , when i select <6 Mth , i like to know how to exclude those fast moving items.

The script should be look some thing like below , but it cannot work :-

if(L_issue = '00/00/0000' AND L_move <> '00/00/0000', ('New Product'),

if(S1 > '0' AND S2 > '0' and S3 > '0', ('Fast Moving'),

If([No of Months_] >= 1 and [No of Months_] <= 6 and S1 |> '0' AND S2 |> '0' and S3 |> '0', Dual('<6 Mth', 1),

If([No of Months_] >= 7 and [No of Months_] <= 12, Dual('>6 Mth-1 Yr', 2),

If([No of Months_] >= 13 and [No of Months_] <= 36, Dual('>2-3 Yr', 3),

If([No of Months_] >= 37 and [No of Months_] <= 60, Dual('>3-4 Yr', 4),

If([No of Months_] >= 61 and [No of Months_] <= 84, Dual('>4-5 Yr', 6),

If([No of Months_] >= 85 , Dual('>5 Yr', 7),

))))))))

Hope some one can advise me.

Paul Yeo

Re: How to avoid select <6 Mth and not turn on Fast Moving ?

paulyeo11 — Fri, 22 Dec 2017 01:20:33 GMT

My QVW

topic Re: How to avoid select <6 Mth and not turn on Fast Moving ? in QlikView

How to avoid select <6 Mth and not turn on Fast Moving ?

Re: How to avoid select <6 Mth and not turn on Fast Moving ?