topic Re: set analysis in QlikView

set analysis

vipin_mishra479 — Tue, 10 Jul 2012 15:48:01 GMT

i want a plant which are coming in vertical = '500060' and what ever the variable pass

MayilVahanan — Tue, 10 Jul 2012 16:28:43 GMT

Hi,

Try this,

=only({<verical = {'500060' } , model = {'$(variablename)'} >} plant)

Make sure that, plant has a single value for vertical and variablevalue

Concat({<verical = {'500060' } , model = {'$(variablename)'} >} plant,',') gives plant with comma separation

Hope it helps

vipin_mishra479 — Wed, 11 Jul 2012 06:50:04 GMT

thanks ramasamy for a reply

i have use if(vertical = '500060' , model = '$(variablename)' >} plant) it gives the correct out put but i want two vartical

at a same time then it not show any value will u please suggest me the helpful answer

Wed, 11 Jul 2012 06:58:37 GMT

Hi,

Try this

MinString ( {$<vertical={'500060','500061'}>} if ( model = variablename , Plant ) )

MinString ( if ( vertical = '500060' or vertical = '500061' , if ( model = variablename , Plant ) ) )

HTH

vipin_mishra479 — Wed, 11 Jul 2012 07:44:33 GMT

sorry its not working bcz i m trying in list box