topic Re: sense scatter chart measure sorting - cummulative measure in App Development

sense scatter chart measure sorting - cummulative measure

demienyu — Sat, 04 Aug 2018 19:32:33 GMT

Hi.

I have some trouble with scatter chart showing ABC-XYZ percents by some dimension (say goods group).

First, I have created simple table with goods group as a dimension and Sales Amount as descending measure. I calculate cummulative sales total and cummulative sales percent for ABC rank. It is simple and it works:

RangeSum(Above($(eSomeSalesExpression), 0, RowNo())) / $(eSomeSalesTotalExpression)

In my scatter chart i have to use ABC percent on X-axis and XYZ variation coef on Y-axis. I tried using same expression as above for "measure 1", but i clearly saw that Scatter does not sort data as Table. As a result i have incorrect data in scatter chart.

I could not find any possibility to sort through some scatter chart property.

Is there any workaround how to make scatter chart work properly?

Re: sense scatter chart measure sorting - cummulative measure

MK9885 — Tue, 07 Aug 2018 17:11:03 GMT

Can you provide screen shot of both the Tables, scatter plot and your simple table?

Re: sense scatter chart measure sorting - cummulative measure

demienyu — Tue, 07 Aug 2018 17:57:56 GMT

Sales data is painted over but believe me it is sorted in descending order.

As u see first dimension field value is not the same.

Re: sense scatter chart measure sorting - cummulative measure

MK9885 — Tue, 07 Aug 2018 18:18:31 GMT

Not an expert in range sum expression but

RangeSum(Above($(eSomeSalesExpression), 0, RowNo())) / $(eSomeSalesTotalExpression)

This expression would take the rows and above function as it is a table

But in other charts as Bar/Scatter/Pie you'd not find the Row or above.

You may have to change the expression to get the same result.

Maybe stalwar1‌ or any other expert can help you write a new expression?

Re: sense scatter chart measure sorting - cummulative measure

demienyu — Wed, 08 Aug 2018 04:55:43 GMT

If the expression is completely wrong I think chart should have no bubbles at all. But it has.

Still thinking the problem is sorting.

I'll wait for experts to come.

Re: sense scatter chart measure sorting - cummulative measure

jonathandienst — Wed, 08 Aug 2018 06:01:51 GMT

In Qlikview, Above() can interfere with sorting in objects like pivot tables. Perhaps above interferes with sorting in certain Sense objects as well?