topic Re: About set analysis in QlikView

About set analysis

nareshthavidishetty — Tue, 01 Dec 2015 12:13:52 GMT

Can any one give the right set analysis for the below expression

=if(Metric=APPROVEDNOTUSED,sum({<RUNTIME={"=max(RUNTIME)"}>}APPROVEDNOTUSED))

arulsettu — Tue, 01 Dec 2015 12:16:35 GMT

try this

sum({<RUNTIME={"=max(RUNTIME)"},Metric={'APPROVEDNOTUSED'}>}APPROVEDNOTUSED)

effinty2112 — Tue, 01 Dec 2015 12:19:00 GMT

Hi Naresh,

Try:

=if(Metric=APPROVEDNOTUSED,sum({<RUNTIME={$(=max(RUNTIME))}>}APPROVEDNOTUSED))

miguelbraga — Tue, 01 Dec 2015 12:22:10 GMT

You can try something like this:

sum({<RUNTIME={$(=max(RUNTIME))},Metric={'APPROVEDNOTUSED'}>}APPROVEDNOTUSED)

Hope it helps

Anonymous — Tue, 01 Dec 2015 12:24:44 GMT

try this:

=sum({<Metric={'APPROVEDNOTUSED'},RUNTIME={'=$(=max(RUNTIME))'}>} APPROVEDNOTUSED))

Kushal_Chawda — Tue, 01 Dec 2015 12:34:14 GMT

try this

sum({<RUNTIME={"=max(RUNTIME)"}>}if(Metric='APPROVEDNOTUSED',APPROVEDNOTUSED))

engishfaque — Wed, 02 Dec 2015 09:18:29 GMT

Dear Naresh,

Please try this one,

=Sum({<Metric = {'APPROVEDNOTUSED'}, RUNTIME = {'$(=max(RUNTIME))'}>} APPROVEDNOTUSED)

Kind regards,

Ishfaque Ahmed