topic Re: select multiple values in fields in QlikView

select multiple values in fields

Wed, 23 Dec 2015 00:00:28 GMT

Hi,

I am comparing yesterday to the same day last year and am trying to find a better way to achieve this. At the moment I am using select in field for 'week of year' and 'day of week'r. This falls over at this time of year though as Week 52 or Week 1 does not cross over between years.

At some stage I will need to look into the fault in the calendar but for the moment I just need a workaround. I know if I manually select the two dates I am interested in it works but as the select in field is part of an automatic process I need to set this up as a trigger.

So far I have got max(FullDate) and max(FullDate)-364 working individually but how do I combine these into a single trigger?

Thanks in advance,

Julian

Re: select multiple values in fields

marcus_sommer — Wed, 23 Dec 2015 16:37:23 GMT

You could try it with two expression like:

sum({< Date = {"=date(today()-1)"}>} value) // yesterday

sum({< Date = {"=date(today()-1 - 364)"}>} value) // same weekday in previous year

Another possibility might be to use daynumberofyear() - maybe within a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus

Re: select multiple values in fields

Wed, 23 Dec 2015 20:44:02 GMT

Hi Marcus, Those expressions would work as well but how do I combine them in a select in field trigger to choose both dates?

Re: select multiple values in fields

marcus_sommer — Thu, 24 Dec 2015 08:17:43 GMT

You could use a search-expression like this one - you need only to adjust the date-format to the format from your date-field:

= '(' & date(today()-1, 'DD.MM.YYYY') & '|' & date(today()-364, 'DD.MM.YYYY') & ')'

- Marcus

Re: select multiple values in fields

Sat, 26 Dec 2015 00:06:45 GMT

Thanks Marcus I was missing the brackets in my expression.