Discussion Board for collaboration related to QlikView App Development.
I have data from Sep 2015 to Apr 2016, I created quarter field, I want previous quarter to display but it wont work.
What is your expression you are using? I am afraid you are providing too little information to be able to offer any help you. Can you elaborate and may be provide a sample?
could you please elaborate your requirement and share some sample data and outputs so that it will be helpful for us to understand
Because of some limitations I am not able to upload actual data, however I have created dummy data as below
I have created date field which is having date from Apr 2016 to Sep 2015, now I want current vs previous quarter value but if I select Q1 of 2016 then previous quarter should be Q4 from 2015.
Check out the attached approach
Dual('Q' & Ceil(Month(Date)/3) & Year(Date), QuarterStart(Date)) as Quarter
(html, codepage is 1252, embedded labels, table is @1);
LOAD DISTINCT Quarter as ReportQuarter,
'CQ' as Flag
AddMonths(Quarter, -3) as Quarter,
'PQ' as Flag
Check this threads and sample QVW
Previous YTQ, QTD, MTD and WTD
Compare quarters (Previous & Current)