Discussion Board for collaboration on QlikView Scripting.
I need to get a field for check last 1 monthj company sales amount .
so i create a partial load script below :-
left join (sales)
sum(if(Month_n<2,sales)) as L6MS
Resident sales group by desc;
Result I wanted :-
Table 1 return correct value 314,474
Table 2 return wrong value. how to make table 2 display 314,474 ?
The reason i make use of Month_n is so that i can replace Month_n<2 to 6 , finally i want to get their last 6 month sales amount.
can u try this:
Resident sales group by desc where Month_n>=2 and Month_n<=6 ;
Resident sales group by desc where Month_n=1;
I prefer to make use of script like :-
sum(if(Month_n=1,sales)) as L6MS
as in my actual QV doc , i have many other script , so i cannot make use where command here.