Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Set analysis

Hi,

I'm getting the below error in set analysis.Please let me know the correct logic.

Untitled.png

Thanks..

11 Replies
sergio0592
Specialist III
Specialist III

Hi, try:

sum($<[Reported Date]= {$(=V_MaxReportedDate)}>} [No Contract Total Amt])

where V_MaxReportedDate is a variable.

Anil_Babu_Samineni

Do you have the field maxreporteddate?

Can you elaborate more please

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)
vishsaggi
Champion III
Champion III

Is your ReportedDate a different field. Are you trying something like this?

= Sum({$< [Reported Date] = '$(= Max(ReportedDate))'  >} [No Contract Total Amt])

Anil_Babu_Samineni

Vishwarath,

Do you mean this?

= Sum({$< [Reported Date] = {'$(=Max([Reported Date]))'}  >} [No Contract Total Amt])

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)
thabang_petje
Partner
Partner

Hi,

try this: sum(if([Reported Date]= ReportedDate, [No Contract Total Amt]))

lakkydev
Creator II
Creator II

let vMaxreported=Max([Reported Date])

sum({<[Reported Date] ={$(vMaxreported)}>}[No Contract Total Amt])

Not applicable

U missed Curly brackets while passing values

rgvavihs
Specialist
Specialist

sum({<ReportDate={'MaxReportDate'}>}NoContractAmount)

eromiyasimon
Creator II
Creator II

Hi,

= Sum({$< [Reported Date] = {'$(=Max(ReportedDate))'}  >} [No Contract Total Amt])

if the field name is maxreporteddate then the set analysis will be

= sum(${<[Reported Date] = {'MaxReportedDate'}>}[No Contract Total Amt])