# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for
Did you mean:  Specialist II

## Help with set expression

Hi,

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

Accepted Solutions  MVP

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%')``````
4 Replies  MVP

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%')``````  Specialist II
Author

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  Specialist II
Author

Hi Sunny,

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

BR,

Vijay  MVP

I don't think so 