topic Re: Help with expression in QlikView

Help with expression

Anonymous — Tue, 02 May 2017 22:58:21 GMT

please find the attached document .. can some one please fix my expression , i am unable to get the execution count value displayed for Task = "client hub load" unless i select it .

Thanks

Re: Help with expression

Anil_Babu_Samineni — Wed, 03 May 2017 02:15:27 GMT

May be this?

Only({<[Rum Metric Time] = {$(=concat( chr(39) & Aggr(Max([Rum Metric Time]), [Rum Task]) & chr(39), ','))},

[Rum Date]={'>=$(=Date(vRUMStartDate))<=$(=Date(vRUMEndDate))'}>} [Rum Execution Count])

Re: Help with expression

antoniotiman — Wed, 03 May 2017 07:44:14 GMT

Hi,

Set Analysis is per Chart, not per Row.

Try

FirstSortedValue({<[Rum Date]={'>=$(=Date(vRUMStartDate))<=$(=Date(vRUMEndDate))'}>} [Rum Execution Count],-[Rum Metric Time])

Regards,

Antonio