Set Analysis Locked the selection

[Anonymous]

Hi, I have a question.

I have a chart with expression like this :

sum({<REGION={'A'}>}QTY)

i have a list box that contains region's value, let's say i have two values, REGION "A" and REGION "B"

When i choose REGION "B", the chart still shown, bcs i'm using the set analysis {<REGION={'A'}>}

Is it possible, if i choose Region B, the chart will shown "No Data Display" ?

Really sorry if my statement is not clear.

Thanks in advance

[swuehl · Accepted solution]

Try the intersection operator:

sum({<REGION *= {'A'}>}QTY)

[Anonymous]

Hi Stefan,

Really thanks, you're my savior !

It solved my problem perfectly.

Thanks in advance.

[#4]

hi Stefan ,

The expression which you given is nothing but to show only REGION A Sales Wright, If  not it need to show no data is available.

I think for this we can also try with a if condition.

[#5]

Hi,

Try this in your chart under General tab in Calculated condition give if(getfieldelections(REGION)='B',0,1)

And if you want to display 'No Data Display' in the chart give the Error messages(Button shown below the chart icons) as No Data Display corresponding to Calculating condition unfulfilled .

Hope this is helpful.

Regards,

Balakrishnan.R