Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucius_Artorius_Castus

When I select on year-month filter bar char should not affect.

Hi Everyone, so I have one filter year-month and one chart with ageing, So ageing chart should not affect when I click on year-month I have provided the expression But the problem is it is changing the sorting order of dimension that's the only problem, Otherwise it is working perfectly so How should I stop it, I have tried everything in properties.
Expression used in measure: Sum({<[YEAR_MONTH]=, [BUCKETS]-={'-', null} >} [GEO_AVG_PRICE] * [GEO_QTY]) / 1000 
without selection of year month order of chart

Lucius_Artorius_Castus_0-1714028333250.png


After selection of filter (order is reversed which should not happen):

Lucius_Artorius_Castus_1-1714028386016.png

Let me know how can I stop sorting change.
Thanks,
Lucious Arotorius Castus

Labels (6)
1 Solution

Accepted Solutions
jchx
Contributor III
Contributor III

It should be your sort expression, gotta use an expression to fix the buckets. See this:

https://community.qlik.com/t5/App-Development/Qlik-Sense-Sort-Expression-with-fixed-values/td-p/1056...

 

View solution in original post

3 Replies
jchx
Contributor III
Contributor III

It should be your sort expression, gotta use an expression to fix the buckets. See this:

https://community.qlik.com/t5/App-Development/Qlik-Sense-Sort-Expression-with-fixed-values/td-p/1056...

 

Lucius_Artorius_Castus
Author

@jchx Thanks, Let me check.

Lucius_Artorius_Castus
Author

@jchx Thank you very much, That worked.