Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

min of a set analysis composed

Hello,

I need to have the min of this set analysis :

(sum({<$(MTD)>} CALLSANSWERED) - sum({<$(MTD)>}CALLSANSWEREDAFTTHRESHOLD))

/

sum({<$(MTD)>}CALLSANSWERED)

Thanks for help

(I used Min like that but it doesn't works :

Min(

(sum({<$(MTD)>} CALLSANSWERED) - sum({<$(MTD)>}CALLSANSWEREDAFTTHRESHOLD))

/

sum({<$(MTD)>}CALLSANSWERED)

)

)

1 Reply
Anil_Babu_Samineni

As always this returns single value only, So that is Min only. To get rid work you need

Min(Aggr((sum({<$(MTD)>} CALLSANSWERED) - sum({<$(MTD)>}CALLSANSWEREDAFTTHRESHOLD))

/sum({<$(MTD)>}CALLSANSWERED), Dim1, Dim2))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)