Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

i want to restrict on one particular customer name in pivot table

Hi All

I want to restrict customer='siva' in dimension of pivot table

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: i want to restrict on one particular customer name in pivot table

Ok, then I probably misunderstood you. I thought you wanted to see only the results for customer siva in the pivot table. If you want to see the results for every customer except customer siva then try expressions like:

sum({<customer-={'siva'}>}Sales)

sum({1-<customer={'siva'}>}Sales)

sum({<customer=E(<Customer={'siva'}>}Customer)>}Sales)


talk is cheap, supply exceeds demand
3 Replies
MVP & Luminary
MVP & Luminary

Re: i want to restrict on one particular customer name in pivot table

Add {<customer={'siva'}>} to all the expressions in your pivot table. For example sum(Sales) becomes sum({<customer={'siva'}>}Sales)


talk is cheap, supply exceeds demand
Not applicable

Re: i want to restrict on one particular customer name in pivot table

Hi Gysbert,

i want to customer siva in qvd but i don't want to see customer siva in the pivot table and his income and profit values also

i had used the expression for the income and profit but customer is in dimension.

Thanks

MVP & Luminary
MVP & Luminary

Re: i want to restrict on one particular customer name in pivot table

Ok, then I probably misunderstood you. I thought you wanted to see only the results for customer siva in the pivot table. If you want to see the results for every customer except customer siva then try expressions like:

sum({<customer-={'siva'}>}Sales)

sum({1-<customer={'siva'}>}Sales)

sum({<customer=E(<Customer={'siva'}>}Customer)>}Sales)


talk is cheap, supply exceeds demand