current day vs previous day

[#1]

Hello,

Im having some trouble by getting my previous day.

Im using this formular

My Current day is

=sum({<CD>} BuyPriceRealized)

//CD is equal to

inday(TempDate, $(vToday), 0) * -1 AS CD,

from my mastercalendar

//This one returns the current day i have selected (I dont wont to show today, cause i dont have data atm) so i want to hardcorded previous day, and im trying to do it by this:

=sum({$<Year={"2012"}, Month={"sep"}, Day{"24"}>} BuyPriceRealized) //I does not show anything, but if i remove day i get the sum from 2012 and sep.. So it seems to be my Day there is a problem with, but i cant figure out what...

Can anyone help??

[#2]

Nope, doesnt work, and no i dont have data from yesterday, only untill the 24th of september

But hardcoded is fine! But it is really strange - but okay, i have only worked with qlikview for 2 weeks, so maybe its just me!!

But im gettin there!

Appreciate your help!

[#3]

Hi John,

Can you please solve this query.

http://community.qlik.com/thread/64255

Thanks and Regards

hsharmas