Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
mell90
Contributor
Contributor

Cumulative filter

Hello , 

I'm new in qlik sense and i need your help,

I have an excel file that contains two dimensions : month and location , in location I have( longitude and latitude)
example of my file :

monthlocation 
Janv[-51.229615293456,2.4980705482816]
Févr[-51.265664182611,1.8832887765734]
Mars[-51.498093687001,1.0266394546589]
Avr[-51.896564434343,1.4466394546589]
Mai[-51.888893687001,1.4566394546589]
Juin[-51.466980368701,1.0266399446589]
Juil[-51.498093694001,1.0266394546469]
Août[-51.498093687571,1.0266394598589]
Janv[-51.49834556678,1.02663977786557]
Févr[-51.999093687571,1.0966394598589]
Mars[-51.498093687871,1.0266394598589]
Avr[-51.4980978787571,1.0266394598589]
Mai[-51.4980937877571,1.0266394598589]
Juin[-51.498093697571,1.0266394598589]
Juil[-51.498576687571,1.0266394598589]
Août[-51.498093678781,1.0266394598589]

 

My problem that i need to use a filtre that :

If month= 'Janv' ,  the filter display  all value of location when moth=Janv

if month=Févr , the filter display  all value of location when moth='Janv' and month=Févr

if month= Mars,  the filter display  all value of location when moth='Janv' and month=Févr and month= Mars

To display  location i use a qlik map .

thanks

Labels (2)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

Not an issue. Use set analysis . i am assuming you have no dates just the month field.
step 1 add another column called MonthNum. Use a map to assign number value to each month
step 2 in your expression something like Sum({<MonthNum={"<=$(MonthNum)"}, Month=>}Sales)
basically set analysis says ignore Month selection and get all monthnums below the selected month