topic Re: Help with set expression in QlikView

Help with set expression

vvira1316 — Fri, 19 Jul 2019 16:23:35 GMT

Hi,

Please review the below image to see my set expression question. I've included sample data and QVW application.

Re: Help with set expression

sunny_talwar — Fri, 19 Jul 2019 16:51:45 GMT

Try this

=Num(Aggr( Sum({<NoDateKey-={''}, [Question Level]={'Primary'}, Response, [Phase Name] = {"=Count(NoDateKey) <> 0"}>} [Proficiency Points])/ Sum(Aggr( Sum({<[Display Name], [Phase Name] = {"=Count(NoDateKey) <> 0"}>} [Max Points]) * Count({<[Display Name], [Phase Name] = {"=Count(NoDateKey) <> 0"}>} DISTINCT NoDateKey) , [Phase Name], [Question Text])), [Phase Name]), '#.00%')

Re: Help with set expression

vvira1316 — Fri, 19 Jul 2019 19:29:45 GMT

Hi Sunny,

As always it is the solution. Thanks a lot.

I'm going to try and understand the approach you take in getting the set expression to work.

BR,

Vijay

Re: Help with set expression

vvira1316 — Fri, 19 Jul 2019 19:39:09 GMT

Hi Sunny,

Would it be possible to do without having a calculated dimension?

BR,

Vijay

Re: Help with set expression

sunny_talwar — Mon, 22 Jul 2019 11:11:27 GMT

I don't think so