topic Re: Set analysis in QlikView

Set analysis

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Thanks..

Re: Set analysis

sergio0592 — Sat, 12 Nov 2016 09:59:59 GMT

Hi, try:

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

where V_MaxReportedDate is a variable.

Re: Set analysis

Anil_Babu_Samineni — Sat, 12 Nov 2016 13:52:36 GMT

Do you have the field maxreporteddate?

Can you elaborate more please

Re: Set analysis

vishsaggi — Sat, 12 Nov 2016 15:50:05 GMT

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

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

Re: Set analysis

Anil_Babu_Samineni — Mon, 14 Nov 2016 05:33:59 GMT

Vishwarath,

Do you mean this?

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

Re: Set analysis

Anonymous — Mon, 14 Nov 2016 06:44:31 GMT

Hi,

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

Re: Set analysis

Anonymous — Mon, 14 Nov 2016 09:11:04 GMT

let vMaxreported=Max([Reported Date])

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

Re: Set analysis

Mon, 14 Nov 2016 09:32:23 GMT

U missed Curly brackets while passing values

Re: Set analysis

Anonymous — Mon, 14 Nov 2016 10:40:23 GMT

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

Re: Set analysis

eromiyasimon — Mon, 14 Nov 2016 10:50:57 GMT

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])

Re: Set analysis

saimahasan — Mon, 14 Nov 2016 12:15:38 GMT

Hi Naresh

Since your MaxReportedDate field must be having only single record, you cantake that value in variable by using

LET vMaxDate = Date(Peek('Max_A',0,'B'));

Then using the set expression:

=Sum({$<Date={"$(vMaxDate)"}>}Sales)

You can get the required output.

Re: Set analysis

vishsaggi — Mon, 14 Nov 2016 16:04:16 GMT

Yes, I missed it. Thanks.