topic Divide the number into equal periods in App Development

Divide the number into equal periods

waleeed_mahmood — Sat, 16 Nov 2024 02:19:27 GMT

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

Re: Divide the number into equal periods

Taoufiq_Zarra — Tue, 26 May 2020 23:08:49 GMT

@waleeed_mahmood

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 :