Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Doubt with expression in graphic

Hi

I have this expression in a bar graph

SUM({<[State] = {'1', '2'}, FLAGESTATE = {'1'}>}FLAGESTATE)

I'd like to see this from the start of the 2014 to the selected month

for example if i select april 2015 i have to see january 2014, february 2014, etc.

What should i do ?

Thank you

Greetings

1 Reply
maxgro
MVP
MVP

if you have y (year) and m (month)

= sum({$<STATE={1,2},FLAGESTATE={1},y={"$(=max(y)-1)"}>

+ <STATE={1,2},FLAGESTATE={1},y={"$(=max(y))"},m={"<=$(=(max(m)))"}>} FLAGESTATE)