Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field called "Narative" and want to display two straight table charts on one sheet. One with Narrative value like 'SETTLEMENT*' and othe other the other with all other values
Hi,
that´s a case to use SET Analysis.
Expression a): Sum({$}Amount) //calculate the amount regarding your selection
Expression b): Sum({1-$}Amount) //calculate all other values but not the selected ones
See also QV help for more details.
Good luck!
Rainer
Hi,
that´s a case to use SET Analysis.
Expression a): Sum({$}Amount) //calculate the amount regarding your selection
Expression b): Sum({1-$}Amount) //calculate all other values but not the selected ones
See also QV help for more details.
Good luck!
Rainer
Use the set analysis function: (in the following I assume that you need to express sum of amounts, adjust the expressions according to your needs)
Expression in chart #1:
sum( { $ < Narrative = {"SETTLEMENT*"} > } Amount )
Expression in chart #2:
sum( Amount )
regards
see in my example
Problem solved - Thanks