topic Re: Previous Day - Set analysis - Not working in QlikView

Previous Day - Set analysis - Not working

Mon, 08 Oct 2012 07:59:04 GMT

Hi All,

I need to be able to display the selected dates data, and the previous days data, but I am not including any date fields in my pivot table.

I am using this expression, but it is giving me 0.

Sum ({$< [As at Date] ={"$(=Only([As at Date])-1)"}>} [MTM P/L(USD)])/1000

Please can you help?

Thanks

Sally

swuehl — Mon, 08 Oct 2012 08:05:33 GMT

Try formatting your set modifier the same way as your date, e.g.

Sum ({$< [As at Date] ={'$(=Date(Only([As at Date])-1,'MM/DD/YYYY')) '}>} [MTM P/L(USD)])/1000

Mon, 08 Oct 2012 08:52:37 GMT

Hi,

Thanks for the quick response.

That still gives me a zero value.

This gives me the same value as the selected days data:

Sum ({$< [As at Date] ={"=$(=Date(Only([As at Date])-1,'MM/DD/YYYY'))"}>} [MTM P/L(USD)])/1000

I have also managed to get a total of all previous values using <=, but I just cannot get the selected value, - 1 day.

Slightly annoying.

SunilChauhan — Mon, 08 Oct 2012 09:03:02 GMT

Sum ({$< [As at Date] ={"$(=Date([As at Date]-1))"}>} [MTM P/L(USD)])/1000

hope this helps

Mon, 08 Oct 2012 09:12:42 GMT

Sunil,

You are a star....thank you so much!!!