Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hkg_qlik
Contributor II

Set Analysis

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

1 Reply
manojkvrajan
Contributor III

Re: Set Analysis

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])

Community Browser