topic Re: Show previous value in table line item in QlikView

Show previous value in table line item

Fri, 26 Feb 2016 12:51:54 GMT

Good Afternoon, all!

I have a straight table for data quality analysis that shows me any suspect values from my source data. In the following example, any field1 value that is negative indicates suspect data. Subsequently, I have a table in qlikview that shows me all such values.

The dimensions of the table are:

Date

Serial Number

Expressions:

=Sum({$<field1={"<$(=0)"}>} field1) -- to only show the suspect values

=Sum({$<field1={"<$(=0)"}>} field2) -- to show the source value (value2 is used in the script to derive value1)

I'm wanting an additional expression to see what the value for field2 was in the previous month, so I assume I need a function similar to the following

=Sum({$<field1={"<$(=0)"}, Date = {"$(=addmonths(Date), -1)"}>} field2)

however this just resolves to '0' on every line item.

Any suggestions on how I can show the previous month's value for the same dimensions, relative to the specific date of the suspect data?

Thanks!

Re: Show previous value in table line item

sunny_talwar — Fri, 26 Feb 2016 18:48:09 GMT

You would need to use Above/Below function (based on sorting of your straight table) to do this.

Re: Show previous value in table line item

Chanty4u — Mon, 29 Feb 2016 06:17:32 GMT

chk dis

How To /Missing Manual (24 articles)

Re: Show previous value in table line item

tresB — Mon, 29 Feb 2016 06:21:47 GMT

May be using Month field like:

=Sum({$<field1={'<0'}, Month= {"$(=Month(addmonths(Max(Date), -1))"}>} field2)

Re: Show previous value in table line item

Tue, 08 Mar 2016 15:39:54 GMT

Thanks for your suggestions, but unfortunately none of these answers were appropriate. I decided in the end to add the expression value in the load script using the Lookup() function.

Thanks again!