Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You would need to use Above/Below function (based on sorting of your straight table) to do this.
May be using Month field like:
=Sum({$<field1={'<0'}, Month= {"$(=Month(addmonths(Max(Date), -1))"}>} field2)
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!