Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Not applicable

Re: Restrict a user name in pivot table

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
Contributor

Re: Restrict a user name in pivot table

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.

Highlighted
rajeshforqlikvi
Contributor

Re: Restrict a user name in pivot table

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

Re: Restrict a user name in pivot table

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
Honored Contributor

Re: Restrict a user name in pivot table

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
Contributor

Re: Restrict a user name in pivot table

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



balrajahlawat
Esteemed Contributor

Re: Restrict a user name in pivot table

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

Could you share your sample app?