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: 
everest226
Creator III
Creator III

Restriction in dimension

HI i have a Pivot table in Sense with two dimension , 

Country Name and   Country Name  & '-' & [New PST]

now i want to exclude  value from  [New PST]      which are  ABC and CBA 

 

 

the result i am getting is i can exclude those value but i am still getting county name  associate with that value.  

1 Solution

Accepted Solutions
sunny_talwar

May be try this

If(Len(Trim([New PST])) > 0, [Country Name] & '-' & [New PST])

and then make sure that you uncheck 'Include Zero Values' for your dimension

View solution in original post

9 Replies
sunny_talwar

How exactly are you excluding them?

everest226
Creator III
Creator III
Author

I created new field in script to exclude them, Field name as [New PST]. 

 

So basically its already exclude , but i am still have Country name associate with that .

sunny_talwar

Why don't you exclude it via set analysis?

everest226
Creator III
Creator III
Author

I have exclude that on measure using set analysis , i still see country name associate with those value , getting 0 on all measure.  

everest226
Creator III
Creator III
Author

=[Country Name] & '-' & [New PST]     this is my expression for second dimension     

 

 

 

sunny_talwar

I am not sure I follow your comment. Can you show this via sample or images?

everest226
Creator III
Creator III
Author

aaja.png

Again first dimension   [Country Name]      and second dimension  =[Country Name] & '-' & [New PST]

sunny_talwar

May be try this

If(Len(Trim([New PST])) > 0, [Country Name] & '-' & [New PST])

and then make sure that you uncheck 'Include Zero Values' for your dimension

everest226
Creator III
Creator III
Author

Thanks Again it just worked fine