topic Re: Syntax Set analysis in QlikView

Syntax Set analysis

Mon, 30 Jun 2014 12:34:28 GMT

Hi!

i am struggling with my first line of set analysis

Sum({<[År Vecka]={'year(today()) & week(today()-1)'},

when i hardcode the value 201426 no problem instead of year(today()) & Week(today()-1)

full statement

Sum({<[År Vecka]={'year(today()) & week(today()-1)'},

Land = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)

any help would be greatly appreciated in using functions with set analysis, otherwise i could perhaps go with an if statement.

Best

Brad

maxgro — Mon, 30 Jun 2014 12:44:28 GMT

maybe

sum({$<[År Vecka]={$(=( year(today())&Week(Today())-1 ))} ,

Land = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)

Mon, 30 Jun 2014 12:47:35 GMT

what is the condition you need to give for [Ar Vecka]

its_anandrjs — Mon, 30 Jun 2014 12:53:31 GMT

Try this way may be

Sum({<[År Vecka]= { '$(=(year(today())&week(today()-1) ))' },

Land = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)

Sum({<[År Vecka]= { '$(=(year(today())& (=week(today()-1)) ))' },

Land = {'E-handel SE'},

DepartmentNo = {'1'}>}

Nettobelopp-InkPris)