New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
MVP

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
MVP

Re: Restriction in dimension

How exactly are you excluding them?

Highlighted
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 .

MVP

Re: Restriction in dimension

Why don't you exclude it via set analysis?

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.

Contributor III

Re: Restriction in dimension

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

MVP

Re: Restriction in dimension

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

Contributor III

Re: Restriction in dimension

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

MVP

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

Contributor III

Re: Restriction in dimension

Thanks Again it just worked fine