Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Show table rows only if value changed

How am I able to display a row only if the value of the attribute has changed compared to yesterday's value?

Please help.

Thanks,

Amit

5 Replies
Anil_Babu_Samineni

May be provide more information?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
vishsaggi
Champion III
Champion III

In your show condition write like?

= IF(Value <> Previous(Value), 1, 0)

But however we need little more information about your expressions used to work on?

edmondo_tassi
Contributor III
Contributor III

It sure we need a little extra infos, however there is also above function.

Anonymous
Not applicable
Author

!I've attached a sample data set.

The ATTRB is the column which can change on a different day. I need to be able to compare the current day selection against yesterday's value for that data and only show it in the table if that ATTRB changed. Hope this makes it a bit clearer in terms of requirements.

vishsaggi
Champion III
Champion III

You don't have a date field in your sample can you add the date field so that we can work on?