Quartile trough 6 weeks

5abi0001 — Thu, 02 May 2019 20:14:50 GMT

Hi! 🙂

I have a question ..

I have the following table:

CalenderWeek, TicketStatus, TicketID

201901 Loose 39182819

201902 Loose 2389192

201903 Win 9293982

201904 Loose 1092830

201905 Win 182038

201906 Win 129392

201907 Win 12983838

Now i have a bar chart .. in the bar chart the dimension is CalenderWeek and in the expressions i have the following:

=count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Win"}>} TicketID)

=count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Loose"}>} TicketID)

The Variable vKWTD calculates for me the 6 weeks for example i choose the kw 201907, vKWTD would be 201901.

THan i have an expression where i calculate a rate for the weeks:

=(count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Win"}>} TicketID))

/ ((count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Win"}>} TicketID)) + (count({$<[KW]={"<=$(=Getfieldselections(KW)) >=$(vKWTD)"}, TicketStatus={"Loose"}>} TicketID)))*100

Now what i want is the first value of the top quartile of this rate within this 6 weeks .. but i dont know how i could do it.

Can you help me?

topic Quartile trough 6 weeks in QlikView

Quartile trough 6 weeks