Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.