Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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?