topic Re: set analyse won't work in QlikView

set analyse won't work

Tue, 06 Nov 2012 10:05:46 GMT

Hi,

Why doesn't this work?

=sum({$<DateShouldBeSend={'<=$(=Max(SelectedDates))'},DateItHasBeenSend={'>=$(=Min(SelectedDates))'} >} hours)

table1

order number

DateShouldBeSend

DateItHasBeenSend

hours

table2

week

year

SelectedDates

there is no connection between table 1 and table 2.

Tue, 06 Nov 2012 10:20:29 GMT

Oh it seems DateShouldBeSend and DateItHasBeenSend where not the same date format.

needed to do Date(DateShouldBeSend,'DD-MM-YYYY') as DateShouldBeSend,

Tue, 06 Nov 2012 11:03:45 GMT

You may try this small change in syntax:

=sum({$<DateShouldBeSend={"<=$(='Max(SelectedDates)')"},DateItHasBeenSend={">=$(='Min(SelectedDates)')"} >} hours)

Regards,

Murali

jagan — Tue, 06 Nov 2012 11:06:40 GMT

Hi,

Check whether all the date dimensions are in the same date format. That may be the problem.

Regards,

Jagan.