Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pre qurter

Dear Members

how do i find qurter analysis

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

Labels (1)
6 Replies
er_mohit
Master II
Master II

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

hope it helps you

Not applicable
Author

Hi

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

Not applicable
Author

hai  working fine

same way prev qtr end require jul-sep

Not applicable
Author

Hi

Below expression to get the Quarterend Date for Previous Quarter.

 

=

QuarterEnd(QuarterName(Today())-1)

~Kabilan K

Not applicable
Author

Thanks for keeping reply

i want value between pre qrt start and pre qrt end

Not applicable
Author

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