If you are using a dollar sign expansion with an expression like
then this will be evaluated first, in global context, not considering any dimensions of your chart (it's like a macro expansion, it will be evaluated before anything else get's done).
Also your set expression is only evaluated once per chart, not considering your dimension
(see this document for more details).
So set analysis alone will not work here, and you probably need to use some other technique, like advanced aggregation.
But it would be good if you could post some more details, best by posting a small sample app that demonstrate your issue.
Thanks for youre reply @swuehl!
You are right that Set-analysis would not work for dual set-analyses, however I have found that it does work for a single set-analyses. When i only use one the expression it will consider my dimension. (see column 2 in Test table in attached file)
Since I cant use dual set analyses for this purpose, could you please elaborate a bit on what you mean by advanced aggregation?
Do you mean aggregating it in the load script?
I have no experience of that, could you give me an example to lead me in the right direction? or eaven better write it in the qv-file?
Thank you for taking time for my issue!
QV community.qvw 695.2 K