Trouble with getting Difference in data over Time.
Hi everybody, I have a problem where I am trying to create a Chart that shows Total Seat Count, Expired Seat Count, and the New Seat Count from month to month. My data has a Space Status Column, a Seat Count and a Date column that I am pulling data from. I have the first 2 inserted into my table but when I try and insert New I run into trouble.
I have defined 2 variables,
Let vMaxMonth = Max(Month); (Where Month is defined in the table load by "Month(Date) as Month")
Re: Trouble with getting Difference in data over Time.
Because I am on a Personal edition of QlikView I cannot open that file as it wasn't created by me. If there another way you can show your solution, such as screenshots, that would be greatly appreciated!
Can you briefly explain why vMaxMonth=Max(Month) does no have a value?