topic Re: On selection chart is not working properly... in QlikView

On selection chart is not working properly...

hamzabob1 — Thu, 16 Jul 2015 06:59:37 GMT

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 — Thu, 16 Jul 2015 07:51:46 GMT

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 — Thu, 16 Jul 2015 10:17:31 GMT

Thanks kumar...

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

thanks..

awhitfield — Thu, 16 Jul 2015 13:06:29 GMT

Hi Hamza,

Can you please upload your qvw?

Andy

antoniotiman — Thu, 16 Jul 2015 16:54:51 GMT

Hi,

Try

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

and

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

Regards,

Antonio

hamzabob1 — Fri, 17 Jul 2015 05:19:20 GMT

awsome...thanks antonio its working..

tysm