topic Set analysis help in calender in QlikView

Set analysis help in calender

dhanu_today — Thu, 29 May 2014 05:16:07 GMT

Hi Everyone,

I have to derive two expressions like A and B with following conditions in the design level with the set analysis is added an advantage.

1)If am selecting FIN_YEAR(2014),CAL_MONTH(March) then A has to show the accounts opening date till March 2013 and B has to show 04/01/2013 to 03/31/2014

If am selecting FIN_YEAR(2015),CAL_MONTH(April) then A has to show the accounts opening date till April 2014 and B has to show 04/01/2014 to 04/30/2014

2) If am selecting FIN_YEAR(2014),CAL_MONTH(March) then A has to show the accounts opening date till March 2014 and B has to show remaining accounts.

The sample data has been attached .

Thanks in adv,

Dhanu

Re: Set analysis help in calender

Thu, 29 May 2014 11:37:32 GMT

Hi dhanu,

May be it will help you,

do following step:

1) QuarterStart(ACCOUNT_OPENING_DATE) as QS,

2) Expression for condition :

only({<ACCOUNT_OPENING_DATE = {">=$(=(Min({<CAL_MONTH=>}ACCOUNT_OPENING_DATE)))<$(=date(max(QS,5)))"},FIN_YEAR=, FIN_QTR=, CAL_MONTH=>} ACCOUNT_OPENING_DATE)

Thanks & regards,

Harshal Patil

Re: Set analysis help in calender

dhanu_today — Thu, 29 May 2014 11:53:16 GMT

Thanks for your time Harshal .Its working in alternate way also.

Dhanu