Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Highlighted
capriconuser
New Contributor III

exclude categories from column

i have one dimension in pivot table like this

Categories

Wood

Color

Crockery

Laptops

here i want to exclude color category from column what i should do ?

1 Solution

Accepted Solutions
MVP
MVP

Re: exclude categories from column

Use calculated dimension. Expression: If(Categories<>'Color', Categories)

And, enable 'Suppress When Value Is Null' in dimension tab

1 Reply
MVP
MVP

Re: exclude categories from column

Use calculated dimension. Expression: If(Categories<>'Color', Categories)

And, enable 'Suppress When Value Is Null' in dimension tab