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

Last 5 Years Data based on selection in year,qtr,month and week

Hi All,

   I am new to Qlikview.

I am having a sheet where when user selects 2014   in year  or 2014-Q1 in quarter or 201401 in month and 2014-W05 in week then user should see the data  for last 5 years based on the selection.

    for ex if user selects 2014 he need to see 2010,11,12,13,14  and 2014Q1 he need to see 2013Q1,Q2,Q3,Q4 and 2014Q1

                   User need to see this information in Pivot table and Charts.

0 Replies