Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

histogramme expression

Good morning

I have a histogram, include the realization trend per month per agency, with the realization for example of February month is the sum between February + January,

i used this expresion fo table , i need to modify this expression because this expression work with selection month and year

sum({<YEAR = {$(=Max(YEAR))}, MONTH, MONTHNUM = {"<= $(=MAX(MONTHNUM))"} ,REAL_CAPITALCLIENT.CONQUETE={"OUI"}>}REAL_CAPITALCLIENT.NOMBRE_CLIENT)

1 Reply
sunny_talwar

Souad - would you be able to elaborate a little on what you are trying to do? What happens when you don't select a month and year?