"Between" dates using set analysis

[#1]

Hi,

I'm old to QV but new to set analysis and was wondering how to do something similar to "variable between date1 and date2" but I can't seem to figure it out. Anybody wanna help me out?

[#2]

one thing I don't understand is why makedate() doesn't default to that format too

[johnw]

It's working for me. I'm doing a sample script with a makedate() in it, changing the SET DateFormat, and on a reload, the format of the date in a chart changes to match the new SET. But like I said, there are a LOT of places that the date format can get overridden, so your application is likely overriding it somewhere.

First place I'd check is the chart, but I'm guessing that isn't it.

Second place I'd check is settings -> document properties -> number -> your field. Does it have a date format? Is "Survive Reload" checked? Hmmm. Interesting, in my example, it DID have a date format, and survive reload WAS checked. I removed it, and put it back, and now it IS functioning as an override, where it wasn't before. Anyway, remove the checkmark on "Survive Reload" if it's there to stop overriding the default, or just set the date format you want to override the default.

[#4]

I just ran into this problem too. Changing the number properties of the field in Document Settings was the fix. I also received the suggestion:

The best way is to use the integer value of the string as in Date#('01/01/2009', 'mm/dd/yyyy')

[#5]

Hi,

i have a german Qlikview, can you hardcopie, where do you changed in Document Settings.

Thanks

[#6]

Hello John, i know this post is old but i think you can help me.

Just as Juan Fibonacci, i want to get the sum of all the sales made between two dates.

this is what i got:

=sum({<Date ={">=01/11/2012 <=01/02/2013"}>} Value)

The result is just the value that has this date value: '01/02/2013' if i take out the '=' it returns 0. For what i understood, it isn't looking for the other values, or something like that.

it worked this way:

=sum({<Date ={">=01/11/2012 <=01/02/2013"},month=,year=>} Value)

it gave me the sum, but there are two details here, first that in my proyect i am not using dates like this "01/11/2012" but as a field. and second that if i use the month=,year= those fields wouldn't work....

I am out of ideas do you have any? thank you.