topic Re: pre qurter in QlikView

pre qurter

Wed, 26 Dec 2012 06:18:37 GMT

Dear Members

how do i find qurter analysis

i want pre qtr(jul-sep) and curr(oct-dec) comparision

er_mohit — Wed, 26 Dec 2012 06:23:17 GMT

{${currentquarter}-1}"<=previous(quarter)>"}

hope it helps you

Wed, 26 Dec 2012 06:46:18 GMT

u can get the Current quarter name through below expression

=QuarterName(today())

u can get the Previous quarter name through below expression

=QuarterName(QuarterName(Today())-1)

So u can use this like below in comparision

=if(QuarterName(QuarterName(Today())-1)<QuarterName(Today()),'True','False')

hope it helps you

~Kabilan K

Wed, 26 Dec 2012 07:22:24 GMT

hai working fine

same way prev qtr end require jul-sep

Wed, 26 Dec 2012 10:04:05 GMT

Below expression to get the Quarterend Date for Previous Quarter.

QuarterEnd(QuarterName(Today())-1)

~Kabilan K

Wed, 26 Dec 2012 17:21:31 GMT

Thanks for keeping reply

i want value between pre qrt start and pre qrt end

Thu, 27 Dec 2012 05:25:04 GMT

Hi U can write a expression like below

Sum({$<Datefield=">=$(=QuarterStart(QuarterName(Today())-1))

<=$(=QuarterEnd(QuarterName(Today())-1))">}Sales)

I hope it helps U...

~Kabilan K