dimensions

[denis115]

Hi!

I have list of all clients and list of a part of clients that are included in "all clients"

I need to see in table clients that are not included in second list of clients

I think its like "allclients-clients2" but it doesnt worked.

Help please 

[tresesco]

Like this?

Load * inline [

SomeClients

1

3

];

Load *,ClientsAll as ClientMissing

Inline [

ClientsAll

1

2

3

4

5

6

] where not Exists(SomeClients,ClientsAll);

[denis115]

yes  but I need to show it in a chart by expression

[tresesco]

Could you provide a sample qvw? Because the solution could vary based on the data model.

[denis115]

It will take a lot of time cause Im using section access.

For example I have an excel file that have as dimension CLIENT10,CLIENTID, 1 and when I select 1 I see all clients that have discount 10% but I need also to see near in a chart all clients that are not included in this list of clients that have discount 10%

[denis115]

I think it maybe something with exception cause when I do it manually it works good

[tresesco]

Try using the following expression to see all clients excluded in a text box.

=Concat(Distinct {<Client=e(Client)>} Client  , ',')

[denis115]

it show same things as simple list box

[tresesco]

Could you share screen shots of the output, selection and expression you are using?

[denis115]

expresion is =

(Sum (SUMI)-Sum (SUMRETURN))