Set analysis help

[#1]

=if([Supplier Preference Category]='Emerging', 'Preferred',[Supplier Preference Category]) 

Set analysis expression for this expression

[jerem1234]

So you are mapping any Supplier Preference Category= 'Emerging' to the label 'Preferred', and everything else keeps their name?

The If statement is the way to go here in my opinion. Not sure if you can get around it without using an if statement somewhere. Why do you need to convert to set analysis? Are you using this as an expression or calculated dimension?

Hope this helps!

[Anonymous]

Reddy,

Your expression is not for set analysis.  Set analysis is for aggregation functions (e.g. sum(), count()...) with a subset of data.  There is no aggregations in your case.  And, there is nothing wrong using if().

If you don't want if() for some reason, try replace():

replace([Supplier Preference Category], 'Emerging', 'Preferred')

But it will work correctly only if the string 'Emerging' exists only in one value of the field [Supplier Preference Category].

Regards,

Michael

[#4]

Using this as an expression. I want show those supplier names which has supplier preference category= emerging and preferred

[#5]

Sorry as dimension

[Anonymous]

It is for set analysis:

aggr(only({<[Supplier Preference Category]={'Emerging','Peferred'}>} [Supplier Name]),[Supplier Name])

[#7]

1. Need to Label the Dimension in BOLD

2 . The supplier preference category feild has these many values .. i need to show only emerging and preferred in my pivot table

Hope you understood now

[Anonymous]

2.  Calculated dimension:

aggr(only({<[Supplier Preference Category]={'Emerging','Preferred'}>} [Supplier Preference Category]),[Supplier Preference Category])

1. To make it bold:
Expand "+"-sign at the dimension, select "Text Format", click Edit, enter '<b>'

Hope you understood now

[#9]

I got you, but i need the label only to change to BOLD

[javier_florian]

You can try with:

=Sum({<[Supplier Preference Category]={'Emerging'}>} [Supplier Name])

Attached you can see a document related with set expression:

http://www.scribd.com/doc/166235706/QlikLearn-Set-Analysis-Presentation

- JFlorián