topic Re: Show table rows only if value changed in QlikView

Show table rows only if value changed

Anonymous — Thu, 07 Sep 2017 14:38:14 GMT

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

Re: Show table rows only if value changed

Anil_Babu_Samineni — Thu, 07 Sep 2017 16:14:54 GMT

May be provide more information?

Re: Show table rows only if value changed

vishsaggi — Thu, 07 Sep 2017 16:20:34 GMT

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?

Re: Show table rows only if value changed

edmondo_tassi — Thu, 07 Sep 2017 16:24:36 GMT

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

Re: Show table rows only if value changed

Anonymous — Thu, 07 Sep 2017 17:09:19 GMT

!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.

Re: Show table rows only if value changed

vishsaggi — Thu, 07 Sep 2017 19:35:17 GMT

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