# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor III

## Condition in straight table

Hi I have the table as below. I want this straight table to display only the priority 1 and 2 tickets with status not equal to closed and resolved.. How to achieve this without any filters.

 Date ID Priority Status 20-06-2013 IN14938 4 Closed 25-06-2013 IN15350 4 Closed 25-06-2013 IN15368 1 Open 26-06-2013 IN15511 2 Hold 26-06-2013 IN15575 4 Closed 01-07-2013 IN15876 3 Closed 08-07-2013 IN16278 3 Closed 09-07-2013 IN16446 4 Closed 18-07-2013 IN17223 4 Closed 19-07-2013 IN17349 4 Closed 19-07-2013 IN17351 4 Closed 19-07-2013 IN17355 4 Closed 19-07-2013 IN17365 4 Closed
Tags (1)
1 Solution

Accepted Solutions
Not applicable

## Re: Condition in straight table

only({<Priority = {1,2}, Status -= {'Closed', 'Resolved'}>} Status) with Priority and Status as Dimensions.

Edit: You can not hide columns in sense.

Solution 2:

Create two calculated dimensions like below and use an expression as =1. Under presentation-tab you hide the expression.

6 Replies
Not applicable

## Re: Condition in straight table

only({<Priority = {1,2}, Status -= {'Closed', 'Resolved'}>} Status) with Priority and Status as Dimensions.

Edit: You can not hide columns in sense.

Solution 2:

Create two calculated dimensions like below and use an expression as =1. Under presentation-tab you hide the expression.

New Contributor III

## Re: Condition in straight table

I am able to create 2 calculated dimensions but I dont know how to add the expression as 1. can you please explain more

Not applicable

## Re: Condition in straight table

You can also try the set analysis expression instead of calculated dimensions.

Othervise:

Put the value 1 in your expression as a "dummy expression". Then hide it under presentation tab and "hide column".

New Contributor III

## Re: Condition in straight table

Can we hide the column in QlikSense?

Not applicable

## Re: Condition in straight table

Oh. sorry I did not see it was in sense.

Then you can use the set analysis expression, hopefully that will work in sense...

//Micke

New Contributor III

## Re: Condition in straight table

I have tried using expression and it works perfect.. Thanks..