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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)