Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

Ignore selections of x-axis dimension (accumulation)

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

ali_hijazi_0-1700816176563.png

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

ali_hijazi_1-1700816306013.png

Kindly advise
@sunny_talwar 

I can walk on water when it freezes
Labels (1)
7 Replies
rajjul
Partner - Contributor III
Partner - Contributor III

rajjul
Partner - Contributor III
Partner - Contributor III

If not try use set expression to ignore x axis dimension

anat
Master
Master

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

ali_hijazi
Partner - Master II
Partner - Master II
Author

I already did this 
it doesn't work

 

I can walk on water when it freezes
Anil_Babu_Samineni

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ali_hijazi
Partner - Master II
Partner - Master II
Author

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

I can walk on water when it freezes
ali_hijazi
Partner - Master II
Partner - Master II
Author

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

I can walk on water when it freezes