Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
everest226
Contributor 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

Re: Restriction in dimension

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

9 Replies

Re: Restriction in dimension

How exactly are you excluding them?

everest226
Contributor III

Re: Restriction in dimension

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 .

Re: Restriction in dimension

Why don't you exclude it via set analysis?

everest226
Contributor III

Re: Restriction in dimension

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

everest226
Contributor III

Re: Restriction in dimension

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

 

 

 

Re: Restriction in dimension

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

everest226
Contributor III

Re: Restriction in dimension

aaja.png

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

Re: Restriction in dimension

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
Contributor III

Re: Restriction in dimension

Thanks Again it just worked fine