topic Re: Set analysis help in QlikView

Set analysis help

Mon, 02 Dec 2013 18:37:28 GMT

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

Set analysis expression for this expression

Re: Set analysis help

jerem1234 — Mon, 02 Dec 2013 19:05:26 GMT

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!

Re: Set analysis help

Anonymous — Mon, 02 Dec 2013 19:06:40 GMT

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

Re: Set analysis help

Mon, 02 Dec 2013 19:15:07 GMT

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

Re: Set analysis help

Mon, 02 Dec 2013 19:18:09 GMT

Sorry as dimension

Re: Set analysis help

Anonymous — Mon, 02 Dec 2013 19:20:45 GMT

It is for set analysis:

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

Re: Set analysis help

Mon, 02 Dec 2013 20:21:20 GMT

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

Re: Set analysis help

Anonymous — Mon, 02 Dec 2013 20:28:43 GMT

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

Re: Set analysis help

Mon, 02 Dec 2013 21:33:24 GMT

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

Re: Set analysis help

javier_florian — Mon, 02 Dec 2013 21:36:18 GMT

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

Re: Set analysis help

Anonymous — Mon, 02 Dec 2013 21:39:09 GMT

Label only - try different styles of the table, for example "light" or "pivot 1".

Another method - "custom format cell". First turn on "design grid". Next, right click on the cell you want to change, and choose "custom format cell". You can make it bold, italic, change color, etc..

Re: Set analysis help

Mon, 02 Dec 2013 21:55:15 GMT

Thank you.

Re: Set analysis help

Tue, 03 Dec 2013 07:08:26 GMT

it will be better if u use same if statement as it is...

Re: Set analysis help

Tue, 03 Dec 2013 07:18:34 GMT

PFA.. Hope it will help you