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

Line Graph Display previous years on selection

I have loaded data and attached a Qlik file that keeps a running count of total "cases" displayed year over year in line a graph.

I am looking for a way on to mimic the default behavior of the line graph on user selection of year (ie show selected year with 3 or 4 years prior data).

One workaround I know of is writing different expression for each year (max(year)-1) etc.. in bar graph mode.  But i was wondering if the same functionality is possible with a line graph.

Thanks all

-Tom

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_168177_Pic1.JPG

QlikCommunity_Thread_168177_Pic2.JPG

hope this helps

regards

Marco

View solution in original post

1 Reply
MarcoWedel

Hi,

one solution could be:

QlikCommunity_Thread_168177_Pic1.JPG

QlikCommunity_Thread_168177_Pic2.JPG

hope this helps

regards

Marco