How to pass the Brand = Hakko into my expression ?

[#1]

Hi All

=If(Count({<BRAND= {'HAKKO', 'BECKHOFF'}>} DISTINCT BRAND) >1, 1, 0)

Now i like to let user select the BRAND_A by them self , instead of now the brand name if fix on HAKKO. So user can choose any brand they like.

Can some one share with me how to modify the expression , so that it can become flexible.

[tresesco]

Remove the set part to allow user selection in  BRAND field, like:

=If(Count(DISTINCT BRAND) >1, 1, 0)

[sujeetsingh]

See the sample

[#4]

Hi All

Both of you get me wrong , my need is i still want to keep the BECKHOFF on my below expression :-

=If(Count({<BRAND= {'HAKKO', 'BECKHOFF'}>} DISTINCT BRAND) >1, 1, 0)

I want to see how you use $ sign to pass the BRAND value to 'HAKKO'

Hope some one can advise me.

Paul

[tresesco]

Can you please elaborate your requirement in words ?

[#6]

Hi Paul........ PFA As of my understand i done this please check BUY column and let me know

[#7]

Hi tres

This morning Jagan help me on the below post , his expression work fine for only those customer buy Hakko and Beckhoff . But now i want to make it flexiable , user may want to select Red Lion or mitsubishi brand instead of hakko..( so that i don't need to create many table)...... Hope you can understand my requirement. 

http://community.qlik.com/thread/100493

[#8]

Hi Sir

Yes i did look at your buy column. but it is not correct , i give you 2 table which show the correct result.

[jonathandienst · Accepted solution]

Paul, try this:

=If(Count({<BRAND+={'BECKHOFF'}>} DISTINCT BRAND) >1, 1, 0)

HTH

Jonathan

[#10]

WOW you again hit the jackpot. Thank