topic Filter data in straight table in QlikView

Filter data in straight table

Fri, 20 Nov 2009 15:06:09 GMT

Hello,

I know it's been discussed several times, but after two full days of searching, I failed in making it work [:(]

Tables :

Relations (= Clients)
Personel (= Account Managers)
Events

I created a straight table which is showing me all the clients and the calculated sales. This table does not rely on previous selections made. But I want to create a table per Account Manager.

Where (and how) can I state in the table to show me only the clients from one of the Accountmangers.

From Table 'Personel', field 'Initials', I thought Calculation Condition : =IF(Initials='AHE') would show me the clients of AHE...

I know, it's stupid, but I cann't get it to work

Filter data in straight table

Fri, 20 Nov 2009 15:26:57 GMT

I'm not sure why you want to place a filter inside the object, why don't you just provide a list box so the end-user can select which account manager they want to see?

Filter data in straight table

Fri, 20 Nov 2009 15:28:02 GMT

If, however, you do have a good reason to filter inside of the object itself then maybe a calculated dimension would work, something like:

=IF(AccountManager='ACE' , AccountManager )

Filter data in straight table

Fri, 20 Nov 2009 15:30:07 GMT

Because each Accountmanager will get its own sheet (apart from the comparison-sheets which are allready made).

The sales-director asked me to make a seperate sheet for each accountmanager.

Filter data in straight table

Fri, 20 Nov 2009 15:35:46 GMT

THX !!!

Like I thought : very simple !

Problems solved !!