Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I'm going crazy with a problem here. I have two set analysis e.g.
sum({$<Group={X}>} ValueA)
and
sum({$<Group={X}>} ValueB)
I have these in a chart (Straight table) and i have them i seperate columns.
Now, i want to divide these to så at first i used the labels to do this in a 3rd column e.g.
A/B
and that worked just fine but when i tried to do this;
sum({$<Group={X}>} ValueA) / sum({$<Group={X}>} ValueB)
in a forth column the numbers got all wrong
What am i doing wrong?
and no, i cannot use the lables because they're not suppose to be in the chart at all and i can't use the "invisible" funktion.
Please help.
//A.
Hi,
Let me make sure, if I had fully understood the issue. You canuse the chart expression labels and it works fine… however, when you use theactual expression QV does not work, is this right? Does your dimension havemultiple values? Please can you post the QV document with some sample data andI’d love try this one…
Thanks - DV
Hi borgannika.
Maybe you can use the Column (x) instead of the column labels.
Your first expression is your first Column.
Try in your expression Column(1)/Columnn(2)
Hope this help.
Regards!