Fractile - QlikView

[satishkurra]

Hi

I'm facing issue in displaying the chart for < 95 percentile values.

Attached is the data, i have for Record Id, Revenue. Gross Margin % is a calculated field in the expression (Gross Margin/Fee Revenue)

I also have expressions for Revenue and Gross Margin % as

Revenue:

Sum({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}[Revenue])

Gross Margin %:

Avg({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}[Gross Margin])

/

Avg({<FiscalYear={'$(vMaxYear)'},Date={'<=$(vMaxDate1)'}, Fiscal_Month=>}[Fee Revenue])

I need to display the chart only for < 95 percentile values.

Can someone help me on the same.

[satishkurra]

Any one?

[satishkurra]

Help

[sunny_talwar]

What is the exact issue you are running into? Can you share a qvw app where you have been trying to make it work and failing? This might help us understand the issue better

[satishkurra]

Hi Sunny

Attached is the data client shared and mentioned to display outliers which are less than 95th percentile values.

Does this make sense now?

Thanks

Satish

[sunny_talwar]

I see the Excel attachment, but I am not sure how is this created and what is that you desire to see. That is why was asking for you to share the qvw file.

[satishkurra]

Attached is the qvw.

If you see the scatter plot all the bubbles are at the same position

I would like to distribute by that it looks better.

Client mentioned display data only for < 95th Percentile and see how it looks like

[sunny_talwar]

Looking for this?

[satishkurra]

I see you supress null values

I attached another file and see sheet 1 with another scatter plot. This is not distributed

[sunny_talwar]

I see the scatter

Are you seeing something else?