Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing only negative values in a pivot table

Hi,


I have a pivot table with many columns, some of them are dimensions and some expressions. I am trying to only see the rows with a negative value in any column. so if any row contains a negative vale only those rows will be displayed in the table. How can i go about this?



Thanks,

1 Solution

Accepted Solutions
Master II
Master II

u can try the expression some thing like this,

if(urexpression values is <0,urexpression.null())--- supress the null values.

View solution in original post

3 Replies
Master II
Master II

u can try the expression some thing like this,

if(urexpression values is <0,urexpression.null())--- supress the null values.

View solution in original post

Master III
Master III

Check this app

Contributor
Contributor

Hi Shiva Reddy,

As per your statement,

if(urexpression values is <0,urexpression.null()) is applicable only when expression is available. but here in my case, i do not have any expression & i want to display field only when any of the data in field has negative values..

and there are around thousands of fields in my table.

Please check and update

Thanks in advance,

Suresh