Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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' ,


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