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]

I fixed connection to my Variable.

How can we remove clients with blanks?

[whiteline · Accepted solution]

I think this condition (bolded) will work:

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

As you don't have data you can't calculate minimum. But you can count distinct MYear for a particular client and compare it with the total distinct number of MYear.

And its better to use Sum(N_Month) as your expression, becuse there are more than one value of  N_Month for a particular MYear.

[Anonymous]

Awesome.

Yes, I use Sum(N_Month).

Thank you so much,

Can I ask you if I have some questions?

[whiteline]

It's better to ask the community

[Anonymous]

Could you help me to combine 2 expression in 1

Condition, which select my Client

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

and avg(MyField)

Thanks in advanced

[Anonymous]

Dimension MYear

It's a chart.

[Anonymous]

Dimension---MYear

It's a chart.

[whiteline]

Expression avg(MyField) with dimension MYear calculates average of MyFields for each MYear.

What do you want to calculate ?

[Anonymous]

Hello again,

I attached the file with expectations and example.

Thanks in advaced,

I played with min condition, but without result

[whiteline]

Your chart with MYear dimension.

What is this expression supposed to calculate ?

avg({ $< Client=, N_Month={">$(=Variable2)"}>}[TC])

(for now it takes current set of data, clears Client selection and selects N_Month values higher than Variable2, then it calculates average for MYear).