You can use a where statement to avoid this data. Consider the following (I have also attached a .qvw):
LOAD * INLINE [
WHERE Number <> '' AND Number <> NULL();
This will return a table that looks like this:
Date Number 4/1/12 1 4/15/12 15 4/23/12 23
Notice that the date of 4/3/12 was avoided since it doesn't contain any data.
test.qvw 145.5 K
thanks for your answer but the thing is i have no values for this months.
I attached the .qvw
As you will see in the attached file the table1 start to show values from nov-2010, but in table 2 there are values from ene-2010
Thanks for any advice
Base.qvw 9.7 MB
The problem is with the expression on the second chart. See the attached .qvw with a different expression. Here it doesn't show the months that don't have data. If you need help writing a different expression, I will need further explanation on what exactly you are trying to calculate.
Base.qvw 7.3 MB