Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

How exactly are you excluding them?

Highlighted
Creator III
Creator III

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 .

Highlighted

Why don't you exclude it via set analysis?

Highlighted
Creator III
Creator III

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

Highlighted
Creator III
Creator III

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

 

 

 

Highlighted

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

Highlighted
Creator III
Creator III

aaja.png

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

Highlighted

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

Highlighted
Creator III
Creator III

Thanks Again it just worked fine