Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ltc
Partner - Creator
Partner - Creator

KPI Default Selection

I need to adjust the expression for my KPI, which is currently:

Sum({<[Category] = {'Direction'}, [Date] = {'3/1/2018'}>} [Value])

I hard-coded the date in the expression, but that's not what I want.  What I want is the following:

If a selection is not applied, I want the default selection to be the max Date.  However, if a Date selection is applied, then I want that to show on the KPI.

The data set is attached.  

Thanks!

Labels (1)
1 Solution

Accepted Solutions
ryo_okabe
Partner Ambassador
Partner Ambassador

Hi,
Try this.

Sum({<[Category] = {'Direction'}, [Date] = {'$(=Max(Date))'}>} [Value])

View solution in original post

1 Reply
ryo_okabe
Partner Ambassador
Partner Ambassador

Hi,
Try this.

Sum({<[Category] = {'Direction'}, [Date] = {'$(=Max(Date))'}>} [Value])