Qlik Community

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 
Search instead for 
Did you mean: 
vvira1316
Specialist II
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.

QuestionImage.png

@sunny_talwar 

1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

4 Replies
sunny_talwar

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

vvira1316
Specialist II
Specialist II
Author

Hi Sunny,

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

BR,

Vijay

 

sunny_talwar

I don't think so