Qlik sense sort chart bar by expression dos not wor for small values

athinadev — Mon, 11 Nov 2019 10:03:21 GMT

Hello,

I am using a bar chart with two selectable dimensions /stack, bar and two selectable measures.

The measures expressions are in variables. The percenatges should be formatted to support many languages

LET vMeasurementsTotal = Num( Count({$<DataType*={'$(cDataType)'}, %AutoId-={'*'} >} Distinct %MasterPrimaryKey) / Count({<DataType*={'$(cDataType)'}>} total Distinct %MasterPrimaryKey) , '0$(DecimalSep)00%', '$(DecimalSep)', '$(ThousandSep)') LET vResultsTotal = Count({$<DataType*={'$(cDataType)'}, %AutoId-={'*'} >} Distinct %PrimaryKey) / Count({<DataType*={'$(cDataType)'}>} total Distinct %PrimaryKey) , '0$(DecimalSep)00%')

The user selects the measure (fox example Results) and the Sorting dimension has the expression

if(GetObjectMeasure()= 'Results' , $(vWestgardMeasurementsTotal) , $(vWestgardResultsTotal) )

The selected Chart Sorting properties are: Sort by expression, Descending - Sort numerically, Descending - Sort alphabetically, Descending

The sorting works but not always. If you see the screen shot I have attached it sorts by expression like this

6.71
3.86
3.09
2.90
......

0.17
0.14
0.14
0.08
0.11 that is wrong
0.08

What I am doing wrong? Any help?

Qlik Sense Enterprise April 2019

Thanks in advance

topic Qlik sense sort chart bar by expression dos not wor for small values in App Development

Qlik sense sort chart bar by expression dos not wor for small values