Count of Days with Fractile function

[shyamcharan]

Hi Experts,

I have data which has the ID, week, dates in the week, the response time in seconds and minutes as shown below.

ID	Week	Date	ResponseTime_Secondds	Min
1	1	01-01-2017	819	13.65
2	1	01-01-2017	495	8.25
3	1	01-01-2017	768	12.8
4	1	01-01-2017	587	9.783333
5	1	01-01-2017	489	8.15
6	1	01-01-2017	510	8.5
7	1	01-01-2017	975	16.25
8	1	01-01-2017	638	10.63333
9	1	01-01-2017	872	14.53333
10	1	01-01-2017	814	13.56667
11	1	01-01-2017	554	9.233333
12	1	01-01-2017	216	3.6
13	1	02-01-2017	529	8.816667
14	1	02-01-2017	945	15.75
15	1	02-01-2017	241	4.016667
16	1	02-01-2017	761	12.68333

As shown in the attached QVW, chart 1 has the 50th percentile values calculated for each individual day using the Fractile function.

In chart 2, I would need to show the count of days in a week that had the 50th percentile value >= 10.5.

The expected result from the data in attached QVW should be Week 1 = 3 and Week 2 = 5 days.

However, I am unable to get it worked.

Can you please help. Appreciate your response.

Regards,

Shyam

[Kushal_Chawda]

Should be calculation logic won't change in Qlik right?

[tresesco]

You are right while saying 'in this scenario'. Since, date is a dimension being used in the chart (or in aggr) and you use the same field in the set analysis( Date={"...), putting distinct works; again 'in this scenario'. . However, had there been more dimensions in aggr/chart and not in the resultant chart.. this would not work.

[sunny_talwar]

Pata nai yaar... I don't fully trust the Fractile function in Qlik.... they have a very unique way of calculating Percentile... whick is why I am hesitant to say that they are the same or not

[sunny_talwar]

But in that case you would have needed to modify your solution also, isn't it

[its_anandrjs]

Check this about the Fractile from Qlik Help

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/ChartFunctions/StatisticalAggreg...

Regards

Anand

[shyamcharan]

Thank you all for quick response.

Thank you Tresesco, Kushal and sunny. All your solutions work. Great!!

[sunny_talwar]

Check how Fractile gets calculated in Qlik

What is the exactly calculation of the fractile function?

[Kushal_Chawda]

Yes, that is why I specified "this scenario"

[Kushal_Chawda]

shyamcharan‌  I would suggest to use set analysis solution as it is always advised. If condition with Aggr impacts the performance of the chart (if data is huge, otherwise no problem).

[tresesco]

Yes, absolutely. I only wanted to establish - the set analysis insensitivity of chart dimension. And yes, kush141087‌'s solution is better 'in this scenario'.