Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Partner
Partner

Quartile calculation with 3 fields

Hello experts,

Quartile needs to be calculated based on Incentive amount.

Granularity is Rep -> Period -> Product -> Incentive.

Fractile function works exact when there is only one dimension and one fact.

With the sample example given below it shows unexpected values. could anyone suggest on this?

Sample data attached below.

Sales RepPeriodProductIncentive
S1Q1P1100
S1Q2P125
S1Q3P121
S1Q3P299
S2Q1P1132
S2Q2P112
S2Q2P335
S2Q3P1200
S2Q3P2200
S3Q1P1200
S3Q2P150
S3Q2P3100
S3Q3P3250
S3Q3P2200
S4Q1P2150
S4Q2P2100
S4Q3P2300
S5Q1P1500
S5Q2P1100
S5Q2P3200
S5Q3P1150
Tags (1)