topic set analysis problem in QlikView

set analysis problem

Wed, 17 Feb 2010 19:47:53 GMT

I like to have the budget next to the 'real' value according the correct date

is this possible with set analysis??

set analysis problem

Wed, 17 Feb 2010 19:48:56 GMT

this is what i would like to have!

set analysis problem

Wed, 17 Feb 2010 20:28:05 GMT

I think the problem is in your date formatting. Use the makedate() function with your input data to make a formatted date value. Your syntax looks sound, but your dates are not being evaluated as dates and as a result, your expression is returning zero.

set analysis problem

Wed, 17 Feb 2010 21:06:39 GMT

i now have this function but the same result

can you give me a hint how to use the make date??

sum({$<Budget_BeginDate={"<=$(=DATE(Reak_Date,'DD-MM-YYYY'))"},Budget_EndDate={">=$(=DATE(Reak_Date,'DD-MM-YYYY'))"}>}Budget_value)

set analysis problem

Wed, 17 Feb 2010 21:27:27 GMT

i changed my example with numbers instead of dates and this also not works

can you please have a look at it

set analysis problem

Wed, 17 Feb 2010 21:37:38 GMT


Jochem wrote:
i now have this function but the same result
can you give me a hint how to use the make date??

sum({tiny_mce_markerlt;Budget_BeginDate={"<=$(=DATE(Reak_Date,'DD-MM-YYYY'))"},Budget_EndDate={">=$(=DATE(Reak_Date,'DD-MM-YYYY'))"}>}Budget_value)
 <div></div>

You have to use makedate during the load script.

Makedate(year, month, day)

So if your input is 01-31-2008, your makedate formula would be makedate(subfield(field_name, '-', 3), subfield(field_name, '-', 1), subfield(field_name, '-', 2)).

set analysis problem

Wed, 17 Feb 2010 22:18:30 GMT

can you please have a look at the other post (problem2.qvw) because in this example i changed the date to numbers, and this also does not work!

set analysis problem

Wed, 17 Feb 2010 23:33:28 GMT


Jochem wrote:
can you please have a look at the other post (problem2.qvw) because in this example i changed the date to numbers, and this also does not work!<div></div>

I can't quite figure out what happened in this one, but your syntax is not correct. I think this is what you were trying to accomplish...

sum({$<Budget_Begin = {'<=$(Real)'}, Budget_End = {'>=$(Real)'}>} Budget_value)

set analysis problem

Wed, 17 Feb 2010 23:53:00 GMT

this is what I was trying to accomplish

real 15 is between 10-20 so budget is 10

real 35 is between 30-40 so budget is 20 etc.