capture previous day changes only

[#1]

Hi QV gurus,

My requirement is to only show only values that has been changed to previous day. Consider below example

Product      Review      Date           Value

A                AA           27-May-15      $10

A                AAA         26-May-15      $20

B                BBB          27-May-15      $5

B                BB             26-May-15      $2

C                CCC          27-May-15      $1

C                CCC          26-May-15      $1

As you can see I want to show only products A and B (since Product C review hasn;t changed compared to previous day), I want to show Straight table like below

Product CurrentRating PreviousRating CurentValue

A           AA                AAA                 $10

B           BBB              BB                   $5

can you please help me how to achieve this. Any help is highly apprciated. Attaching qvw for quick reference

[antoniotiman]

Hi,

see attachment.

Regards,

Antonio

[#3]

Hi Antonio,

Thanks for quick response, but only Current date should be selcted by default but table should also show previous day review. is this possible ?

[sunny_talwar]

Modified ANTONIO MANCINI‌'s application to add {<Date =>} in the expression and dimension. May be this helps:

Best,

Sunny

[antoniotiman · Accepted solution]

Try to add {1} in FirstSortedValue({1}.....  in Calculated Dimension

[#6]

thank you suninida it worked amazing well..