I have facing a problem in handling dates in a QlikView Dashboard I have been working on.
I am attaching a sample QV document.
What I am trying to achieve.
In a Text Box, I want to show current balance and in another text box I want to show previous day balance. I use MAX(Date) and MAX(date,2) for second maximum date available. I also have loaded Master Calendar script on it.
First problem: There is no Sundays in my database, so if the current day is Monday, previous day should be Saturday, but this is not the case here, it shows Sunday and since is are no data for Sundays, the expression returns 0.
Second Problem: When ever select a date in History, the previous day expression sometimes returns the result, sometimes it doesn't, upon checking my database, the previous day exists. i-e If I select 14th Jan, the previous day should be 13th Jan.
I would be grateful if anyone helps me out with this.
