topic Re: Ignore selections with accumulation in App Development

Ignore selections of x-axis dimension (accumulation)

ali_hijazi — Sat, 25 Nov 2023 15:30:40 GMT

Hello
got two graphs with the same expression and dimensions but the one on the right is set to display the cumulative percentage that is shown in the first graph

in the second graph I used the rangesum and above functions and I accomplished the desired result
However in the second graph I want to ignore selection made on the values of the dimension on the x-axis
it works on the first graph but doesn't work on the second graph unless I remove the second dimension (area)
kindly advise on how to solve this issue

on the second graph when user clicks on one of the values the graph shows result for that value
what I want is keep accumulation regardless of any selection of values on the x-axis

Kindly advise
@sunny_talwar

Re: Ignore selections with accumulation

rajjul — Fri, 24 Nov 2023 10:12:56 GMT

Try Comparative Analysis and it can be solved easily.

https://community.qlik.com/t5/Design/Alternate-States-for-Comparative-Analysis-in-Qlik-Sense/ba-p/2066081

Re: Ignore selections with accumulation

rajjul — Fri, 24 Nov 2023 10:14:01 GMT

If not try use set expression to ignore x axis dimension

Re: Ignore selections with accumulation

anat — Fri, 24 Nov 2023 11:28:31 GMT

you may try using alternative state or bypass the dims in set analysis

Re: Ignore selections with accumulation

ali_hijazi — Fri, 24 Nov 2023 11:48:31 GMT

I already did this
it doesn't work

Re: Ignore selections with accumulation

Anil_Babu_Samineni — Fri, 24 Nov 2023 19:58:34 GMT

You can ignore the field that user selected to see result from the second graph.

Like, If this is your expression Sum(Sales) try like this, Sum({<FieldName>} Sales)

Re: Ignore selections with accumulation

ali_hijazi — Fri, 24 Nov 2023 20:15:23 GMT

It's not working with accumulation or while using range sum

Re: Ignore selections with accumulation

ali_hijazi — Fri, 24 Nov 2023 20:17:03 GMT

It's works only if there is one dimension in the graph