Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Restrict a user name in pivot table

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 .

Labels (1)
16 Replies
Not applicable
Author

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.

rajeshforqlikvi
Creator
Creator

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.

rajeshforqlikvi
Creator
Creator

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';

Not applicable
Author

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

HirisH_V7
Master
Master

Hi ,

Like this,

Expression:-

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



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

-Hirish

HirisH
“Aspire to Inspire before we Expire!”
rajeshforqlikvi
Creator
Creator

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':



Anonymous
Not applicable
Author

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

Could you share your sample app?