topic Re: Set Analysis in QlikView

Set Analysis

Mon, 14 Mar 2016 10:26:07 GMT

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.

Re: Set Analysis

jeroen_wagner — Mon, 14 Mar 2016 10:28:52 GMT

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

Re: Set Analysis

jeroen_wagner — Mon, 14 Mar 2016 10:30:50 GMT

Ever had a look at the SA-Wizard btw?

Set Analysis Wizard for QlikView | qlikblog.at

Re: Set Analysis

kkkumar82 — Mon, 14 Mar 2016 10:31:42 GMT

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

Re: Set Analysis

Mon, 14 Mar 2016 10:46:43 GMT

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.

Re: Set Analysis

sunny_talwar — Mon, 14 Mar 2016 10:53:11 GMT

May be an expression like this in list box:

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

Re: Set Analysis

Mon, 14 Mar 2016 11:02:17 GMT

Thanks Sunny T saved me some time.