Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

1 Reply
paulyeo11
Valued Contributor II

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

My QVW

Community Browser