Set Analysis problem with Chart Figures Association

[#1]

Hi Everyone,

Just want to ask if you guys have workarounds or suggestion to fix my problem,

I have this expression with set analysis below on a variable (vPRCount)

• Count({$<[PRPO PR Status] = -{'No PR'}>} DISTINCT [PRNo.])

then I have a Pie chart which uses the same field([PRPO PR Status]) above as its dimension and the variable(vPRCount) as its expression. The expression works and calculate properly but my problem is when I select a data in the field([PRPO PR Status]) the chart object is not associating with the selection.

For reference please see screenshots below of the object with and without the selection

     

   

Thanks !

Regards,

Charles

[tresesco · Accepted solution]

I guess negation symbol is misplaced for that desired behavior, it should come before '=' sign. Try:

Count({$<[PRPO PR Status] -={'No PR'}>} DISTINCT [PRNo.])