Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be an expression like this in list box:
=If(Right(EntityCode, 2) <> '-X' and Right(EntityCode, 4) <> '-X-X', EntityCode)
Can you upload your app so we can help you a bit better?
Ever had a look at the SA-Wizard btw?
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
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.
May be an expression like this in list box:
=If(Right(EntityCode, 2) <> '-X' and Right(EntityCode, 4) <> '-X-X', EntityCode)
Thanks Sunny T saved me some time.