# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor III

## [straight table] - Shoing only values that are greater than X

Hello,

I'm struggling about getting somùething simple but I can't figure it out

Let say I have 1 dimension

1 Expression that calculate the amount for Day 1

1 Expression that calculate the amount for Day 2

And the difference between the amounts (Column(1) - Column(2))

I need  to  show only the lines where the Difference is greater than

Example : X = 50

I need to show only the first row

 A DAY 1 DAY 2 DELTA B 100 50 50 C 100 90 10

Thank you very much

1 Solution

Accepted Solutions

Try this way as dimension to work out and suppress null value.

=Aggr(If(SUM({< day = {'22/12/2020'}>}amount)-SUM({< day = {'21/12/2020'}>}amount)>=50, dim), dim)

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)
8 Replies

Can't you simplify like this?

If( (Column(1) - Column(2))>=50,  (Column(1) - Column(2)))

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)
Contributor III
Author

Hello Anil,

Well if I add this as an expression it will still show all the line but with an empty value for those where the condition is not fullfilled

What you want to fill the values where it is null? Please change accordingly as per your needs from red part.

If( (Column(1) - Column(2))>=50,  (Column(1) - Column(2)), '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)
Contributor III
Author

No actually I want just the line that fullfill the condition of Column(1) - Column(2) > X

Will you able to share sample and explain the issue. It will be easy to demonstrate the issue

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)
Contributor III
Author

yes here it is

Try this way as dimension to work out and suppress null value.

=Aggr(If(SUM({< day = {'22/12/2020'}>}amount)-SUM({< day = {'21/12/2020'}>}amount)>=50, dim), dim)

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)
Contributor III
Author

Hello

Many thanks it's working very well 🙂

Community Browser