Set Analysis

[#1]

Hope some one can help me on this I have a List Box and a Multi Box that shown Division in 1 and site in another. The data that populates this can be either at Site,Division or Business level. Can I use Set Analysis to return only Site or Division Names and not show blank or UnKnown. If so can some one give me an example. I have used it to do sum, count and % but never remove.

Thanks in Advance.

[jeroen_wagner]

Can you upload your app so we can help you a bit better?

[jeroen_wagner]

Ever had a look at the SA-Wizard btw?

Set Analysis Wizard for QlikView | qlikblog.at

[kkkumar82]

Hi ,

could you post a qvw with sample data .

As far as I understood, you can write like this.

functionname({<fieldname1 = {'Site', 'Division'}>} fieldname2)

Thanks

Kiran Kumar

[#5]

This is the data we load into the QVD where we give it a proper name but any of the one's that end in -x or -x-x are shown as Unknown and these are the ones we wish to remove. Hope this helps. I can't send anything else as my client is a Government contractor.

[sunny_talwar · Accepted solution]

May be an expression like this in list box:

=If(Right(EntityCode, 2) <> '-X' and Right(EntityCode, 4) <> '-X-X', EntityCode)

[#7]

Thanks Sunny T saved me some time.