Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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)
1 Solution

Accepted Solutions
MVP
MVP

Re: Restrict a user name in pivot table

May be this:

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

16 Replies
MVP
MVP

Re: Restrict a user name in pivot table

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

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

Not applicable

Re: Restrict a user name in pivot table

Hi Sunny

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

i can see only siva remaining is not coming

balrajahlawat
Esteemed Contributor

Re: Restrict a user name in pivot table

Dont forget to tick Suppress Null Values option as well

MVP
MVP

Re: Restrict a user name in pivot table

May be this:

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

balrajahlawat
Esteemed Contributor

Re: Restrict a user name in pivot table

try like this:

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

Not applicable

Re: Restrict a user name in pivot table

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 )

balrajahlawat
Esteemed Contributor

Re: Restrict a user name in pivot table

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

Not applicable

Re: Restrict a user name in pivot table

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

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,

Regards,
Prashant Sangle
Community Browser