Two charts on same sheet with different selections of same field

[Anonymous]

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

[#2 · Accepted solution]

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

[#3]

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

[sparur]

see in my example

[Anonymous]

Problem solved - Thanks