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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

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
Luminary
Luminary

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