Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Set Analysis to include Future Data

What I want is to display one row for each APP_DATE with the max(FCST_DATE) showing as 12/31/2015.

2-2-2016 2-57-36 PM.jpg

I have created a Variable for max(FCST_DATE) = vMaxFCST_DATE

  Only include FCST_AMTs for dates equal to or greater than the m

ax(APP_DATE) where ACT_AMT >0 (APP='ACTUAL').

For example, even though we are in February, we won't yet have any ACT_AMT data for APP_DATE in January so the FCST_AMT sum SHOULD include the FCST_AMT from APP_DATE in January.

   

I need some help to get the view above.

Sum({$<APP_DATE={">$(=Max({<ACT_AMT={'>0'}>}APP_DATE))"},FCST_DATE={$(vMaxFCST_DATE)}>}FCST_AMT)

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Compare it with this one:

Sum({$<  APP_DATE={">$(=Max({<ACT_AMT={'>0'}>}APP_DATE))"},  FCST_DATE={"$(=date(max(FCST_DATE), 'MM/DD/YY')))"}>}FCST_AMT)


talk is cheap, supply exceeds demand

View solution in original post

6 Replies
MVP & Luminary
MVP & Luminary

Maybe this:

=round(Sum({$<FISCAL_YEAR=,APP_DATE={">$(=date(Max({<ACT_AMT={'>0'}>}APP_DATE), 'MM-DD-YYYY'))"}>}FCST_AMT), 1000)/1000


talk is cheap, supply exceeds demand
Specialist
Specialist

Thanks  - that helps for the <APP_DATE={">$(=Max({<ACT_AMT={'>0'}>}APP_DATE))"} part.

Specialist
Specialist

What's wrong with this syntax?

=Sum({$<APP_DATE={">$(=Max({<ACT_AMT={'>0'}>}APP_DATE))"}, FCST_DATE=date(max(FCST_DATE), 'MM/DD/YY'))>})FCST_AMT)

MVP & Luminary
MVP & Luminary

Compare it with this one:

Sum({$<  APP_DATE={">$(=Max({<ACT_AMT={'>0'}>}APP_DATE))"},  FCST_DATE={"$(=date(max(FCST_DATE), 'MM/DD/YY')))"}>}FCST_AMT)


talk is cheap, supply exceeds demand

View solution in original post

Specialist
Specialist

that gives me Error in set Modifier Expression.

MVP & Luminary
MVP & Luminary

Works for me:

comm203870.png


talk is cheap, supply exceeds demand