Quarter into month

[#1]

Can anyone tell how to convert quarter quota into montlyquota? I am attaching excel for reference. there is Salesperson id and quarter date with quota.

[oknotsen]

Divide the number by 3.

[sunny_talwar]

Are you looking for a specific output?

[MarcoWedel]

Hi,

one solution to create three months out of one quarter value could be:

table1:
CrossTable (Salesperson, Quota)
LOAD * FROM [https://community.qlik.com/servlet/JiveServlet/download/1006109-218416/quota.xlsx] (ooxml, embedded labels, table is Sheet1);

table2:
LOAD MonthName(F1,IterNo()-1) as Month,
    Salesperson,
    Money(Quota/3) as Quota
Resident table1
While IterNo()<=3;

DROP Table table1;

hope this helps

regards

Marco