topic Re: Current Year Qtr and previous year with Qtr in QlikView

Current Year Qtr and previous year with Qtr

amita1621 — Mon, 12 Feb 2018 06:17:09 GMT

I have a Period of format '4q 2017' and i want to go to '3q 2017' . by maxstring(period) i get '4q 2017' but how should i reach to '3q 2017'.

I tried maxstring(period)-1 but it doesnt work.

Any solution on this??

Re: Current Year Qtr and previous year with Qtr

tresB — Mon, 12 Feb 2018 06:24:25 GMT

How did you create this field in the script? Could you post that statement?

Re: Current Year Qtr and previous year with Qtr

amita1621 — Mon, 12 Feb 2018 06:50:07 GMT

I textbox i wrote

=MaxString(Period)

which provided output as 4Q 2017

for secondtextbox i wrote

=MaxString(Period)-1

which gives blank result

Re: Current Year Qtr and previous year with Qtr

tresB — Mon, 12 Feb 2018 06:59:52 GMT

Thanks for the information. However, that didn't answer my query above. Could you post your sample qvw? You have to understand how maxstring() works; what the field type you are applying this expression to get the expected output. If you want one quarter back value by simply subtracting 1, then your field has to be created in the script accordingly; and that is probably a dual field and not just as a string. If you can share your sample app, we may help you suggesting a solution fits for your case.

Re: Current Year Qtr and previous year with Qtr

amita1621 — Mon, 12 Feb 2018 10:39:54 GMT

Hi,

PFA the sample Qv file.

Re: Current Year Qtr and previous year with Qtr

tresB — Mon, 12 Feb 2018 11:14:56 GMT

Yours is text field. Ideally this should have been created in the script as a dual field. However, to deal with this in the UI there would be many ways like using complex if..then..else along with string functions. I used another way of parsing the date and then to apply date functions..

=Ceil(Month(AddMonths(MakeDate(Right(Period,4),left(Period,1)*3),-3))/3) &'Q ' & Year(AddMonths(MakeDate(Right(Period,4),left(Period,1)*3),-3))

Re: Current Year Qtr and previous year with Qtr

amita1621 — Mon, 12 Feb 2018 12:01:05 GMT

This doesnt work in my data . Only Q is shown as result. and its working in the sample data provided

Re: Current Year Qtr and previous year with Qtr

tresB — Mon, 12 Feb 2018 12:08:06 GMT

Dear Amita,

That mostly like means, your sample data is not really representative sample of your actual data. And without knowing that (how your actual data is), it would be very hard for us to keep guessing and suggesting a probable solution. I would rather suggest you to provide more information about your data, or get the logic what I suggested above and try to solve yourself from there onward.

Re: Current Year Qtr and previous year with Qtr

amita1621 — Mon, 12 Feb 2018 12:09:48 GMT

Thanks