Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vipin_mishra479
Contributor II

set analysis

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

4 Replies

Re: set analysis

Hi,

     Try this,

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

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

      or

    

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

     Hope it helps

vipin_mishra479
Contributor II

Re: set analysis

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

Not applicable

Re: set analysis

Hi,

Try this

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

or

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

HTH

vipin_mishra479
Contributor II

Re: set analysis

sorry its not working bcz i m trying in list box

Community Browser