Only show row if specific value in column

[YannikPrill]

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 🙂

[Anil_Babu_Samineni]

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

[YannikPrill]

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

[ChennaiahNallani]

[Anil_Babu_Samineni]

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

[YannikPrill]

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

Sorry but I really am very new to this.

[anseglko]

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.

[ChennaiahNallani]

[YannikPrill]

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

[Anil_Babu_Samineni]

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])