Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Only show row if specific value in column

Hey everyone,

 

I have a table where in one column I have 2 alternating values. I only want the rows of saif table to be shown if the value in the column is "1". Since the column is a measure and not a dimension I dont know how to exclude null values.

This is the formula I'm using for the column:

 

Count({<[Inc Service Name]={'FIS-BMW-PAM-Gespräch'}, [Inc Status Display String]={'Rejected', 'Assigned','In Progess','Waiting for','Change open','Finished'}>}[Inc Status Display String])

 

Although it says to count the values the only 2 options that can occure are "1" and "-".

 

Thx for the help in advance 🙂

9 Replies
Highlighted

I think simply disable the null values using "Suppress when value is null" 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

Excuse me for asking that stupid but where do I find that function?

 

As I said I did not know you could suppres null values for measures. I thought you could only do that for dimensions?

 

Greets,

Yannik

Highlighted
Creator III
Creator III

clipboard_image_0.png

Highlighted

Which object you are using? Are you not seeing "Data Handling" --> Option?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

I do not even know how to enter the menu shown in the picture 😕

 

Sorry but I really am very new to this.

 

Highlighted
Creator
Creator

I think he's using Qlik Sense, not View

 

In Qlik Sense you can deselect "Include Null Values" from the dimension of your table. So press the table and then on the right panel click the first tab which should be the main column of your table.

Highlighted
Creator III
Creator III

 

clipboard_image_1.png

clipboard_image_2.png

Highlighted
Contributor II
Contributor II

Hey everyone 🙂

 

Thx for the support!!

Still this does not solve my problem. I found the data handling and tried to unselect the zero values but no results. Do I have to specify the formula which is given within the data handling? Maybe select the column I want the zero values to be excluded from?

 

Greets,

Yannik

Highlighted

Could you please share your sample work file to test? Perhaps this way?

Count({<[Inc Service Name]={'FIS-BMW-PAM-Gespräch'}, [Inc Status Display String]={'Rejected', 'Assigned','In Progess','Waiting for','Change open','Finished'}>} If(Len([Inc Status Display String])>0 or Not IsNull([Inc Status Display String]), [Inc Status Display String])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)