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

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
Gysbert_Wassenaar

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

View solution in original post

3 Replies
Gysbert_Wassenaar

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
Author

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

Gysbert_Wassenaar

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