topic Ignore + Selection + dimension + Pivot in QlikView

Ignore + Selection + dimension + Pivot

Thu, 29 Mar 2012 06:02:42 GMT

Hi All,

Good morning, Hope u all doing good.

I have an issue in QV pivot table..

if I select Asset class (Equities) .. CLIENT_TIER in Pivot table for Aberdeen CLIENT_GROUP_NAME goes to Null(-) .. I know this is because that is a Null value

but requirement is that it should not show as Null, but it should show as Tier2 ..

So what ever is select CLIENT_TIER should not change

Thanks in advance

Ignore + Selection + dimension + Pivot

Thu, 29 Mar 2012 06:15:36 GMT

Qlikview works like this.

Once you made a selection, it likes picking a set of data.

If you select 'Equities', then all data with 'Equities' is picked up.

Therefore, 'Aberdeen' should not been shown in the pivot table and the same as 'Tier 2' for Aberdeen in 'Client_Tier'.

But you force to show 'all value' for the client name. So, it will show 'Aberdeen'

Re: Ignore + Selection + dimension + Pivot

Thu, 29 Mar 2012 06:28:46 GMT

Hi Hanwong_Velocity,

Thanks for your quick response, I know once I select ‘Equities’ there is no activities that the reason ‘Client_Tier’ is showing as null.

But requirement is that I have to show all the CLIENT_GROUP_NAME as well as CLIENT_TIER for what ever is selected .. so only sum of activities as to change(show) in that pivot table ..