Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please review the below image to see my set expression question. I've included sample data and QVW application.
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%')
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%')
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
Hi Sunny,
Would it be possible to do without having a calculated dimension?
BR,
Vijay
I don't think so