set Set Analysis between dates

[Anonymous]

hey guys

Ive been trying to make this set analysis work but i just keep on getting 0

sum({$<Datetime ={"$(<(date(max({1}Datetime)-1)))    $(>(date(max({Datetime)-15)))"}>}tests)

what am i doing wrong????

[#2]

Use something like this

=Sum({$<closeDate = {">=$(=vstartdate)<=$(=venddate) "}>} sales)

Instead of vstartdate and venddate, you can use expression to derive your date also.

=Sum({$<Datetime = {">=$(=date(max(Datetime )-15)) <=$(=date(max(Datetime )-1)) "}>} tests)

[MayilVahanan]

Hi

Try like this

sum({$<Datetime ={"<$(date(max({1}Datetime)-1))  >$(date(max(Datetime)-15))"}>}tests)

For set analysis
http://community.qlik.com/docs/DOC-2895

http://community.qlik.com/docs/DOC-3872

[Anonymous]

hey

i cant use Var

and sadly this to

sum({$<Datetime ={"<$(date(max({1}Datetime)-1))  >$(date(max(Datetime)-15))"}>}tests)

didnt work thanks guys

any other ideas

[kaushiknsolanki]

Hi,

     This might not have worked because the date format will be different.

     Meaning the format for the field Datetime and the value which you are checking ({"<$(date(max({1}Datetime)-1))  >$(date(max(Datetime)-15))"}) should be same.

     Kindly check that.

Regards,

Kaushik Solanki

[jonathandienst]

Hi

Give this a try:

sum({$<Datetime ={"<$(=date(max({1} Datetime) - 1)) >$(=date(max({1} Datetime) - 15))"}>}tests)

Regards

Jonathan

[jldengra]

Hello, Jonathan.

In some of the QlikTech courses it is recommended to convert dates to numbers in order to be used in Set Analysis, since sometimes it does not work properly using a date value.

Being aware of this issue, whenever I need to use dates in set analysis I create additional fields with the num(field) value, and I work only with numeric format for dates, and they always work properly.

I hope this helps.