Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi
Have a look at the attached. Is this what you need?
Regards
Jonathan
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
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
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