topic Re: Restrict a user name in pivot table in QlikView

Restrict a user name in pivot table

Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

I want to restrict a particular customer name in a pivot table dimension.

i am using customer in pivot table as dimension i don't want to see customer=siva in that chart .

Re: Restrict a user name in pivot table

sunny_talwar — Wed, 06 Jan 2016 12:42:29 GMT

Replace customer dimension with a calculated dimension: If(customer <> 'siva', customer)

alternatively you can use set analysis in your expression: {<customer -= {'siva'}>}

Re: Restrict a user name in pivot table

Wed, 06 Jan 2016 12:57:48 GMT

Hi Sunny

=IF([Receiver Name]<>'*siva*',[Receiver Name])

i can see only siva remaining is not coming

Re: Restrict a user name in pivot table

Anonymous — Wed, 06 Jan 2016 13:04:04 GMT

Dont forget to tick Suppress Null Values option as well

Re: Restrict a user name in pivot table

sunny_talwar — Wed, 06 Jan 2016 13:09:13 GMT

May be this:

If(not WildMatch([Receiver Name], '*siva*'), [Receiver Name])

Re: Restrict a user name in pivot table

Anonymous — Wed, 06 Jan 2016 13:18:00 GMT

try like this:

=if(not [Receiver Name] like '*siva*', [Receiver Name])

Re: Restrict a user name in pivot table

Thu, 07 Jan 2016 06:38:00 GMT

Hi Sunny,

Thanks

Receiver name is coming blank but for the siva customer profit and income is coming

i want to restrict siva profit and also income (that is written in expression )

Re: Restrict a user name in pivot table

Anonymous — Thu, 07 Jan 2016 08:25:04 GMT

Did you check Suppress with Null Values option in dimension tab?

Re: Restrict a user name in pivot table

Thu, 07 Jan 2016 08:36:48 GMT

Hi Balraj,

i had supress null values

i want to restrict customer siva name(dim) and it s income and cost also in (expression)

i dont want to show siva and it associative values in expression.

Re: Restrict a user name in pivot table

PrashantSangle — Thu, 07 Jan 2016 08:37:14 GMT

Hi,

Another solutions can be

Create new field in script which excludes siva from Receiver Name

try like

if(not wildmatch([Receiver Name],'*siva*'),[Receiver Name]) as New_Receiver_Name

and use New_Receiver_Name as your dimension.

Note: You can achieve the required solution suggested by Sunny Need to tick supress Null from dimension.

Also Conditional Dimension is performance Killer.

Regards,

Re: Restrict a user name in pivot table

Thu, 07 Jan 2016 08:46:30 GMT

Hi Dreamer,

Thanks for the quick response

if i am using New_Receiver_Name it is showing blank i need to surpress null values know .

i am using pivot table in which 5 (dim) i want to expand only 3 by default if it expand's for their shape is change how to get read of it.

Re: Restrict a user name in pivot table

rajeshforqlikvi — Thu, 07 Jan 2016 09:20:18 GMT

Hi ,

If you have limited customers like not more i mean 5 to 10 then you can use nested if condition like below

If( Customers = 'AAA' , 'AAA',

If (Customers = 'BBB' , 'BBB',

If(Customers = 'CCC' , 'CCC')))

Include all customers in the nested if condition except customer = siva.

Re: Restrict a user name in pivot table

rajeshforqlikvi — Thu, 07 Jan 2016 09:39:42 GMT

Go to the script level and where you have load the customers table, write a where condition like

Directory;

LOAD Customers,

AAAAA,

BBBBB,

CCCCC

FROM

[Rajesh.xlsx]

(ooxml, embedded labels, table is Mysheet) where Customers<>'Siva';

Re: Restrict a user name in pivot table

Thu, 07 Jan 2016 10:04:23 GMT

Hi Rajesh,

i should load the customer siva

Nested if is not possible because some millions of customers

but i restrict only in one pivot table

Re: Restrict a user name in pivot table

HirisH_V7 — Thu, 07 Jan 2016 10:12:41 GMT

Hi ,

Like this,

Expression:-

=Sum({<Customer-={'Name to be Removed'}>}Sales)

or else in your back end script where Customer<>Siva;

-Hirish

Re: Restrict a user name in pivot table

rajeshforqlikvi — Thu, 07 Jan 2016 10:16:29 GMT

Load the Customers table twice and only use customers field in the newly loaded table like below :

Customers:

Directory;

LOAD Customers as CustomersForPivotDimentionOnly,

FROM

[Rajesh.xlsx]

(ooxml, embedded labels, table is Mysheet) ';

NewCustomers:

Load

CustomersForPivotDimentionOnly

resident Customers where CustomersForPivotDimentionOnly <> 'Siva':

Re: Restrict a user name in pivot table

Anonymous — Thu, 07 Jan 2016 10:23:33 GMT

When you restrict Siva and suppress null option, it shound not give you any associative information for Siva.

Could you share your sample app?