Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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