topic Re. :selection of value from ref table in QlikView

How to select previous quarter from ref table

Mon, 31 Jan 2011 09:58:04 GMT

Hi,

I have a ref table like the following.

Month_No, Month, Quarter
1 , Jan , Q1
2, , Feb , Q1
5 , May, , Q2

Qns 1:
I'm trying to create a text object to determine current month so i can get the quarter value.
i tried using pick(), but it requires me to make selection on month first.
i wanted it to be no selection because it's a fixed text box.

Qns 2:
Based on the above table structure, to determine previous Q,
Now is Jan 2011, so previous Q should be 'Q4 2010'.

Thanks

Re. :selection of value from ref table

martin59 — Mon, 31 Jan 2011 10:17:51 GMT

Hello,

You have to use the QuarterName() function :

QuarterName(Today())

Re. :selection of value from ref table

Mon, 31 Jan 2011 10:59:50 GMT

But the value i'm trying to get is in Q1 . Q2 ....

QuarterName returns Jan-Mar 2011.

Re. :selection of value from ref table

Mon, 31 Jan 2011 11:35:50 GMT

If i do this , it is able to detect the correct quantity of the value.

and now i just need to make the value to show.

any idea?

=COUNT({$<MONTH={'$(=month(today()))'}>} Quarter)

How to select previous quarter from ref table

Mon, 31 Jan 2011 12:50:36 GMT

Hello,

You can try a autonumber.
Based on Year, Month and Quarter.


Load
Autonumber(Year, Month, Quarter) as OrderQuarter
Resident Master_Calendar;

After, you can make a subtraction to get the previous quarter, with set analyis.


Sum({$<OrderQuarter={$(=(Max(OrderQuarter))-1)}>} Sales)
Only({$<OrderQuarter={$(=(Max(OrderQuarter))-1)}>} Quarter)