Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis

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.

1 Solution

Accepted Solutions
Highlighted

Re: Set Analysis

May be an expression like this in list box:

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

View solution in original post

6 Replies
Partner
Partner

Re: Set Analysis

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

Partner
Partner

Re: Set Analysis

Ever had a look at the SA-Wizard btw?


Set Analysis Wizard for QlikView | qlikblog.at

kkkumar82
Valued Contributor III

Re: Set Analysis

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

Not applicable

Re: Set Analysis

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.

Highlighted

Re: Set Analysis

May be an expression like this in list box:

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

View solution in original post

Not applicable

Re: Set Analysis

Thanks Sunny T saved me some time.