Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

praveen1108
Contributor

Where condition in Expression in a Table

Hi,

Can any one help me if i have to write a where condition in expression for my Table how can we do that.

I know if we have a measure then we can do Sum({<BU={"Finance"}>} Amount) but without measure how can we do that.

Regards,

PK

1 Solution

Accepted Solutions
harsh44_bhatia
Contributor

Re: Where condition in Expression in a Table

If you do not wish to do this in expression, the other way is to make dept as a calculated dimension.

if(Dept<>'Finance',Dept) and under the properties of calculated dimension select suppress where value is NULL.

4 Replies

Re: Where condition in Expression in a Table

Can you give an example of what you tying to achieve?

praveen1108
Contributor

Re: Where condition in Expression in a Table

I have a data grid or table showing some list of records and i wanted to put a filter where some Dept='Finance' which is a flag.I wanted to do in an expression not in data load Editor

For Example: this is my table and i have some no of records like

SerialNo  Description  Dept      

100          XXX          Finance   

2000        YYY           Support   

and i want to fetch only Dept='Finance'

Regards,

PK

harsh44_bhatia
Contributor

Re: Where condition in Expression in a Table

If you do not wish to do this in expression, the other way is to make dept as a calculated dimension.

if(Dept<>'Finance',Dept) and under the properties of calculated dimension select suppress where value is NULL.

praveen1108
Contributor

Re: Where condition in Expression in a Table

Thank you very much harshit..It helped me...