topic SET EXPRESSION in QlikView

SET EXPRESSION

upaliwije — Sun, 14 Aug 2016 04:28:54 GMT

My following set expression does not produce the expected result.

=NUM({<DEPT={'CITY'},MONTH={'JUL'}>}$(vNetClaim),'#,##0.')

This set moidifier I think is not in the correct place. pls correct me

marcus_sommer — Sun, 14 Aug 2016 04:56:02 GMT

There is an aggregation missing then set analysis worked only within them, maybe you could change your expression to:

=NUM(only({<DEPT={'CITY'},MONTH={'JUL'}>} $(vNetClaim)),'#,##0.')

- Marcus

upaliwije — Sun, 14 Aug 2016 05:17:09 GMT

Thanks

It is still not working

But this part works well =NUM ($(vNetClaim),'#,##0.')

marcus_sommer — Sun, 14 Aug 2016 05:18:37 GMT

How looked $(vNetClaim)?

- Marcus

upaliwije — Sun, 14 Aug 2016 05:30:52 GMT

vNetClaim=sum(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))

marcus_sommer — Sun, 14 Aug 2016 05:35:50 GMT

You couldn't use your variable in this way - your expression should be look like:

num(sum({<DEPT={'CITY'},MONTH={'JUL'}>}

rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)),'#,##0.')

- Marcus