QlikView App Dev

[vvira1316]

Hi,

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

@sunny_talwar 

[sunny_talwar · Accepted solution]

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%')

[vvira1316]

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

[vvira1316]

Hi Sunny,

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

BR,

Vijay

[sunny_talwar]

I don't think so