Isn't it a Simple Expression?

[eleni_theodorid]

Dear All,

I really need help! I can't do this simple thing.

I want to have in one chart 2 dimensions (Date & Date-(a number of days e.g. 365)) and 2 expression 1 for the amount for the first dimesion and one for the amount for the second dimension.

I have attached a test qvw.

Please help me.

Helen

P.S. I don't realy want 365 days, so I can't play with year or date functions based on year. I want to give a spesific number of days (356). Thanks in advance.

[jonathandienst]

Hi

Have a look at the attached. Is this what you need?

Regards

Jonathan

[eleni_theodorid]

Dear Jonathan,

Thank you for your help, I have already try these but I really don't get it. Why it didn't work for Date and it works for DateDim???

Regards,

Helen

[eleni_theodorid]

Dear All,

Sorry for bothering again but Jonathan's suggestion didn't work for our data. When we are trying to do this on real data it can't do the calculation on the chart (see: attached and try to create the chart with the suggested expressions).

Thanks in advance,

Helen

[jonathandienst · Accepted solution]

Helen

With your data, the island table must be created with a LOAD DISTINCT - it has 361 distinct values, but 332000 actual values. You only want the distinct values.

Island:

LOAD DISTINCT Date As DateDim

Resident Data;

Then perhaps it will work

Regards

Jonathan