topic Re: capture previous day changes only in QlikView

capture previous day changes only

Wed, 27 May 2015 15:10:25 GMT

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

Re: capture previous day changes only

antoniotiman — Wed, 27 May 2015 15:59:53 GMT

Hi,

see attachment.

Regards,

Antonio

Re: capture previous day changes only

Wed, 27 May 2015 16:08:50 GMT

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 ?

Re: capture previous day changes only

sunny_talwar — Wed, 27 May 2015 16:13:30 GMT

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

Best,

Sunny

Re: capture previous day changes only

antoniotiman — Wed, 27 May 2015 16:15:25 GMT

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

Re: capture previous day changes only

Thu, 28 May 2015 16:46:01 GMT

thank you suninida it worked amazing well..