Set Analysis

hkg_qlik — Tue, 12 Mar 2013 18:38:41 GMT

Hi,

Here is the scenario:

Account Name Account Code Department YTD Actual Approved Budget

License Fee 100 1000 2000 10,000

Calendar Field Available : YEAR and MONTH-YEAR

I want to display Approved Budget based on following rule:

---- " A user can select any Year value or Month-Year field. The Approved Budget should populate according to the Year selected and the Month should always be december of that year for any month-year selected.

For Example:

User selected: Year 2012 and Month: June (Actual budget: should be DEC-2012)

if user selects: Year 2011 and Month: March (Actual budget: should be DEC-2011)

Account Name Account Code Department YTD Actual Approved Budget

License Fee 100 1000 2000 10,000

Re: Set Analysis

manojkvrajan — Tue, 12 Mar 2013 20:35:13 GMT

Declare a variable LET vMonthYear = chr(39)&'DEC'&'-'&YEAR&chr(39); and use the following set analysis and it will work

sum( {$<[MONTH-YEAR]={$(vMonthYear) } >} [ApprovalBudget])

topic Re: Set Analysis in QlikView

Set Analysis

Re: Set Analysis