Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cseward1963
Contributor

Excluding certain values from a table

Hello All.  I have a table with several dimensions and billing category totals.  One of the dimensions is Student ID.  If possible, I'd like to exclude Student ID = 0 (zero).  Student ID zero  refers to "Non-Student" time (traveling, etc). 

Thanks.

1 Solution

Accepted Solutions

Re: Excluding certain values from a table

You can do like this

If([Student ID] = 0, Null(), [Student ID])

6 Replies

Re: Excluding certain values from a table

May be use this in your expression

{<[Student ID] -= {'0'}>}

cseward1963
Contributor

Re: Excluding certain values from a table

Hi Sunny.  Where would I place this expression?

Also, unrelated to this, I added a profile picture to my profile and it doesn't who on my name icon.  Do you see my profile picture?

OmarBenSalem
Esteemed Contributor

Re: Excluding certain values from a table

you add it in ur measure:

sum({<[Student ID] -= {'0'}>}YourMeasure)

to answer ur second question: u add ur photo as an AVATAR so that It can be seen when u comment

cseward1963
Contributor

Re: Excluding certain values from a table

THank you Omar.  StudentID is not a measure, it is a dimension.

Re: Excluding certain values from a table

You can do like this

If([Student ID] = 0, Null(), [Student ID])

cseward1963
Contributor

Re: Excluding certain values from a table

Thank you Sunny, this worked!  and I learned something useful ! 

Community Browser