topic Re: Isn't it a Simple Expression? in QlikView

Isn't it a Simple Expression?

eleni_theodorid — Mon, 09 Apr 2012 14:52:23 GMT

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.

Re: Isn't it a Simple Expression?

jonathandienst — Mon, 09 Apr 2012 15:54:45 GMT

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

Regards

Jonathan

Isn't it a Simple Expression?

eleni_theodorid — Mon, 09 Apr 2012 18:30:57 GMT

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

Re: Isn't it a Simple Expression?

eleni_theodorid — Tue, 10 Apr 2012 12:17:05 GMT

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

Re: Isn't it a Simple Expression?

jonathandienst — Wed, 11 Apr 2012 20:09:10 GMT

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