Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

   

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

Capture.PNG

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.

Capture.PNG

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

Capture.PNG

Capture2.PNG

kvijay173
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

kvijay173
New Contributor III

Re: Condition in straight table

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

Community Browser