topic HELP WITH CHART CONDITION in QlikView

HELP WITH CHART CONDITION

Anonymous — Thu, 20 Sep 2012 14:52:09 GMT

Hi guys,

I need your help to create a 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.

Please see my attached file.

Anonymous — Thu, 20 Sep 2012 17:57:56 GMT

I need 3 lines in my chart:

1st shows TOTAL (all clients who have more than Variable2)

2nd - INDUSTRY (all clients in selected INDUSTRY who have more than Variable2)

3rd - CLIENT (selected Client who has more than Variable2).

Please see my attached file.

I added 3 tables, which show the right result, if I select N=10 and Industry=eee and Client=B

avg({ $< Client=, N_Month={">$(=Variable2)"}>}[TC]) it was an idea to calculate all client in selected Industry.

If I select Client, Industry and Client lines are the same.

I don't know how select them

Anonymous — Thu, 20 Sep 2012 20:44:27 GMT

Please help me to add condition ignore Selected

Client=,

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

Anonymous — Fri, 21 Sep 2012 20:23:58 GMT

is it possible to create variable which will use only selected Clients.

than use this variable in expression somehow