Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

   

DateIDPriorityStatus
20-06-2013IN149384Closed
25-06-2013IN153504Closed
25-06-2013IN153681Open
26-06-2013IN155112Hold
26-06-2013IN155754Closed
01-07-2013IN158763Closed
08-07-2013IN162783Closed
09-07-2013IN164464Closed
18-07-2013IN172234Closed
19-07-2013IN173494Closed
19-07-2013IN173514Closed
19-07-2013IN173554Closed
19-07-2013IN173654Closed
1 Solution

Accepted Solutions
Not applicable
Author

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.

Capture.PNG

View solution in original post

6 Replies
Not applicable
Author

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.

Capture.PNG

Anonymous
Not applicable
Author

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
Author

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

Capture.PNG

Capture2.PNG

Anonymous
Not applicable
Author

Can we hide the column in QlikSense?

Not applicable
Author

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

Anonymous
Not applicable
Author

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