Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jansen28
Contributor III
Contributor III

Sorting Order by Dimension in Bar chart - not working as expected

Hi All,  I have a requirement to freeze all the objects in a particular tab. While applying the freezing condition, the sort order is not working as expected in a bar chart. The bar chart as one dimension "Threshold" with Value = <10K, $10K - $100K, >100K, NULL and expression sum(Spend ). only for reporting_date filter the bar chart should change but for any other filters it should not change and has to be freezed. I used the below condition to freeze the object by referring the below link ->

https://community.qlik.com/t5/QlikView-Documents/Ignore-all-selections-except-some-specific-fields-u...


Expression used:
sum({$<[Dimension1] = {'Value1'}, $(= '[' & Concat({1<$Field-={Reporting_date,[Dimension1]}>} $Field,']=,[') & ']=')>} Spend)

Expected: On any filter applied the sort order of Threshold should always remains the same like <10K, $10K - $100K, >100K, NULL

Issue: For reporting_date filter the threshold order remains the same but on any field when filtered the order gets changed like <10K, NULL,  >100K, $10K - $100K etc.

Please provide any suggestion? 

Appreciate your help greatly!

Thanks,

Jan

 

Labels (2)
2 Replies
Brett_Bleess
Former Employee
Former Employee

Here are a couple of Design Blog posts that should help:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Actually, just the one link, at the bottom of that post is a link to another post regarding exclusions etc.  I suspect the combination of things should help get you on the right track with things.

If you want direct help, generally it is best to attach QVW file to the thread so folks can check the data model and chart and expressions to be sure they get you the correct code, otherwise bit of a guess as to whether what they offer may work or not...

If you want to search further in the Design Blog area, use the following URL for that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
sunny_talwar

May be try this

Sum({1<[Dimension1] = {'Value1'}, Reporting_date = $::Reporting_date>} Spend)