topic Re: QuarterYear selection for YoY in QlikView

QuarterYear selection for YoY

Mon, 17 Nov 2014 07:42:29 GMT

Hello all,

i have a table with YoY% (comparison between 2 years), I have a field called QtrYear which will have values like 2014/Q1, 2014/Q2, 2014/Q3 etc.

Now, if I select 2014/Q1 from QtrYear field, table should display YoY% for 2014Q1 vs 2013Q1.

Kindly let me know how this can be done.

Thanks for your help.

Regards,

Sheela

ecolomer — Mon, 17 Nov 2014 07:45:30 GMT

You need to created a field with Q1, Q2, Q3, Q4 values and select this filed to have you need

Mon, 17 Nov 2014 07:50:49 GMT

hi Enrique,

Thanks for your quick response.

I do have separate Qtr field in the application, but I wanted to know if YoY% can be calculated even when selecting values from QtrYear field.

Thanks,

Sheela

PradeepReddy — Mon, 17 Nov 2014 08:13:01 GMT

try something like this...

Current Year-Qtr: sum({<YearQtr={'$(=maxstring(YearQtr))'}>}Sales)

Previous Year-Qtr: sum({<YearQtr={'$(=((left(MaxString(YearQtr),4)-1)&right(MaxString(YearQtr),2)))'}>}Sales)

Modify these expressions as per your requirement...

Tue, 18 Nov 2014 07:46:48 GMT

hi Pradeep,

thanks for your reply, but this does not seem to work.

Thanks

Sheela

Tue, 18 Nov 2014 08:25:46 GMT

Generally users will select Year and Qtr and look at YoY,
in case, they select QtrYear, then also YoY should be displayed.

this is my concern.

Thanks

Sheela

Tue, 18 Nov 2014 08:49:47 GMT

Calculate start month and end month and use addmonths() function