Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
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!
Hi John,
Can you please solve this query.
http://community.qlik.com/thread/64255
Thanks and Regards
hsharmas