Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
kathy_parker
Contributor
Contributor

Expression needed - % of a cell in two columns

Columns names are "Suspense > 90 days" and "Suspense < 90 days".  Valuation date column contains the month end date (See table below).

I need to be able to find out:  Of the total suspense for May 2018, what part of this total is the Suspense < than 90 days.

I have a variable created vCurrentDate =Date#(Max(ValuationDate)).   I have used this in other formulas to populate the most current information.

Sum({$<ValuationDate={'$(vCurrentDate)'}>}[Suspense >90 days])

Suspense > 90 daysSuspense < 90 daysValuation Date
10002501/31/2018
12503002/28/2018
9502003/31/2018
5756584/30/2018
325125005/31/2018

Can someone help me with this expression please?

0 Replies