Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculation of previous qtr value

hi experts,

i have the list box for calendaryearquarter.

also i have calendar years 2014, 2015

i have set variables for current quarter & previous quarters as below

vPreviousQtr= if(GetSelectedCount(CalendarYearQuarter)<>1,'' &if(RIGHT(CalendarYearQuarter,1)=1,LEFT(CalendarYearQuarter,4)-1 & ' Q4' ,

LEFT(CalendarYearQuarter,6)&(RIGHT(CalendarYearQuarter,1)-1)))

vMaxQuarter=YEAR(MAX(DATE)) & ' Q' & MAX(CEIL(Month/3))

there are some sales amount for every quarter which is in a chart

when i select on a particular quarter, it should display the current quarter name in one chart & previous quarter name in another chart.

i.e., for ex if i select Q2, one chart will have Q2 & other will have Q!.

for all the quarters except Q1, its working fine. if i click on Q1 2015, it should display 2014 Q4 as well. but it is not.

Please give some suggestions to make it out

0 Replies