exclusion

[Anonymous]

Hi everyone,

I would like to add following condition: if any particular client has less that N (variable that I enter) records in any given month, and then take off this client from the table completely.

I misunderstood something.

It's my expression-which remove data in any given month,if condition applies

sum({$<N_Month={">$(=Variable2)"}>} N_Month)

I have dimension Client.

I'm expecting to see, if any value in the data is less than the input, hide the client.

Please see my link.

http://community.qlik.com/message/260343#260343

Thanks,

[Anonymous]

Sorry, I didn't understand.

If I select last 3 months (MYear variable), it should be show me only clients who have more than my minimum N.

What's wrong?

[whiteline]

I think I've missed something.

"more than my minimum N" in the last selected 3 months or in all periods ?

[whiteline]

In case you want to filter your clients only by selected period use {<Client=>} set instead of {1} within the Industry expression:

=avg({$<Client={"=Min({<Client=>}aggr(Sum({<Client=>}N_Month), MYear, Client))>$(Variable2) and (count({<Client=>} total<Client> distinct MYear)=count({<Client=>} total distinct MYear))"}>}[OSAT])

[Anonymous]

Ok.

I want to dynamically select Period(MYear), Minimum N, industry and Client.

This expression works well in dimension (if I select Period or not, minimum N or Industry or Client)

=aggr(if(Min(aggr(Sum(N_Month), MYear, Client))>Variable2 and (count(total<Client> distinct MYear)=count(total distinct MYear)), Client, null()), Client)

I found only problem with selection  (before any selection in Industry or Client, it shows all clients for selected Period and minimum N --- TOTAL (it's good). I select Industry, it show all clients in this Industry.  the 3 step I select client, it show only my client.

the idea to see in a chart

1. line -for TOTAL (all clients across all industries)

2. line- for Industry (all clients across selected Industry)

3. line -for Client (only selected Client)

that I'll be able compare them according condition MYear (selected period) and minimum N.

[whiteline]

The same approach with TOTAL as above, just clear Industries in sets as well:

=avg({$<Client={"=Min({<Client=, Industries=>}aggr(Sum({<Client=, Industries=>}N_Month), MYear, Client))>$(Variable2) and (count({<Client=, Industries=>} total<Client> distinct

MYear)=count({<Client=, Industries=>} total distinct MYear))"}, Industries=>}[OSAT])

[Anonymous]

Now that's right.

Thank you so much. You relly helped me.

Thank you again.