Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

How to use max function with interval in dashboard

Hi,

I am trying to use Max() function for below expression, and I am getting error in expression:-

if((Interval(


max(sum({<[WO edited new value]*={'Closed'},[WO edited field]*={'Field_Status__c'},[Owner = Editor]={'Yes'},[Work detail sub line type] = {'Labor'},

[WO retrospective]={'Correctly created'}>}

[WO edited date time]))-


max(sum({<[WO edited new value]*={'Closed'},[WO edited field]*={'Field_Status__c'},[Owner = Editor]={'Yes'},[Work detail sub line type] = {'Labor'},

[WO retrospective]={'Correctly created'}>}

[Work detail end date time]))


,'hh')*24)<24,'Yes','No')


output should be 'Yes' or 'No'


Please suggest.

1 Reply
Gysbert_Wassenaar

You are nesting two aggregations functions: max(sum. That's only possible if you use the aggr function so you can specify what dimension(s) the outer aggregation function needs to aggregate over. So you need something like max(aggr(sum(....), Dim1, Dim2, ... DimN)).

Replace Dim1, Dim2, ... DimN with the dimensions over which the sums should be grouped to calculate the max of the sums.


talk is cheap, supply exceeds demand