On selection chart is not working properly...

[hamzabob1]

Hello Experts,

I have one problem can u please help me out..

in the above figure i am selecting Domestic so idealy it has to show only one bar but its showing both.

Expression am usings is:-

=fabs(Count({$<INV_CRN={'INV'},[SEGMENT AIR]={'Domestic'}>}DISTINCT(INVOICE_AND_REFUND_ID))

-

Count({$<INV_CRN={'CRN'},[SEGMENT AIR]={'Domestic'}>}DISTINCT(INVOICE_AND_REFUND_ID)))

and same for International.

Thanks in advance.

[sushil353]

Hi,

This is happening because you have two different expression calculated explicitly for SEGMENT AIR = Domestic and international.

to disable on expression on selection of the list box there are two ways.

1. Add a second dimension SEGMENT AIR and use only one expression and remove SEGMENT AIR condition from setanalysis.

2. For both expression use conditional enable as if(isnull(getfieldselection(segment air) or getsubstringcount([SEGMNET AIR],'Domestic'), 1,0)

Same with international

HTH

Sushil

[hamzabob1]

Thanks kumar...

but both the solution are not working...is there any other solution..

thanks..

[awhitfield]

Hi Hamza,

Can you please upload your qvw?

Andy

[antoniotiman · Accepted solution]

Hi,

Try

[SEGMENT AIR-={'Domestic'}          //International

and

[SEGMENT AIR]-={'International'}     //Domestic

Regards,

Antonio

[hamzabob1]

awsome...thanks antonio its working..

tysm