Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all,
is there a way to do this in Qlik?
In words, I want to divide the amount into 3 equal parts and assign periods based on the Quarters. So for example, the 3rd last row is divided into 3 equal parts and assigned period 10,11,12.
Q1: 1,2,3
Q2: 4,5,6
Q3: 7,8,9
Q4: 10,11,12
please let me know if you have any questions.
thanks,
waleed
several option, for example :
Data:
LOAD * INLINE [
BU, KPI, Amount, Qtr
a, s, 120, 1
z, d, 150, 1
e, f, 140, 3
r, c, 160, 4
t, r, 1500, 4
];
left join
load * inline [
Period,Qtr
1,1
2,1
3,1
4,2
5,2
6,2
7,3
8,3
9,3
10,4
11,4
12,4
];
output:
load *, Num(Amount/3,'# ##0,0') as New_Amount resident Data;
drop table Data;
input table :
output table :
several option, for example :
Data:
LOAD * INLINE [
BU, KPI, Amount, Qtr
a, s, 120, 1
z, d, 150, 1
e, f, 140, 3
r, c, 160, 4
t, r, 1500, 4
];
left join
load * inline [
Period,Qtr
1,1
2,1
3,1
4,2
5,2
6,2
7,3
8,3
9,3
10,4
11,4
12,4
];
output:
load *, Num(Amount/3,'# ##0,0') as New_Amount resident Data;
drop table Data;
input table :
output table :