Re: Show table rows only if value changed - Qlik Community

Anonymous · ‎2017-09-07

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

Anil_Babu_Samineni · ‎2017-09-07

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 · ‎2017-09-07

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 · ‎2017-09-07

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

Anonymous · ‎2017-09-07

!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 · ‎2017-09-07

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