topic Re: set Set Analysis between dates in QlikView

set Set Analysis between dates

Anonymous — Mon, 11 Nov 2013 17:04:57 GMT

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????

Re: set Set Analysis between dates

Mon, 11 Nov 2013 17:10:49 GMT

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)

Re: set Set Analysis between dates

MayilVahanan — Mon, 11 Nov 2013 17:14:20 GMT

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

Re: set Set Analysis between dates

Anonymous — Tue, 12 Nov 2013 08:37:46 GMT

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

Re: set Set Analysis between dates

kaushiknsolanki — Tue, 12 Nov 2013 08:46:19 GMT

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

Re: set Set Analysis between dates

jonathandienst — Tue, 12 Nov 2013 08:51:47 GMT

Give this a try:

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

Regards

Jonathan

Re: set Set Analysis between dates

jldengra — Tue, 12 Nov 2013 10:29:09 GMT

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.