topic Re: Set analysis syntax in QlikView

Set analysis syntax

Thu, 30 Jan 2014 18:33:22 GMT

hi i have attempted the folllowing two statements without success;

if([Year Week] = weekyear(today()) & num(Week(today()),00),

sum({<%ArtKat = {93}>}OrderRad.NettoBelopp))

sum({<%ArtKat = {93},[Year Week] = {weekyear(today()) & num(Week(today()),00) }>}OrderRad.NettoBelopp)

any suggestions would be greatly appreciated.

Best

Brad

Message was edited by: Bradley Coyne

Re: Set analysis syntax

Thu, 30 Jan 2014 18:40:10 GMT

Hi,

You need simple quotes around your Num format: '00'

With this you second statement could work...

Is [Year Week] a number or a string?

Re: Set analysis syntax

Thu, 30 Jan 2014 18:42:25 GMT

string

Re: Set analysis syntax

Thu, 30 Jan 2014 18:46:46 GMT

hello thank you for your reply, i have attempted this however no success, still shows error, with a missing bracket...

Re: Set analysis syntax

Thu, 30 Jan 2014 18:49:07 GMT

OK. Then you can try with the quotes:

sum({<%ArtKat = {93},[Year Week] = {weekyear(today()) & num(Week(today()),'00') }>}OrderRad.NettoBelopp)

If it doesn't work, you can try:

sum({<%ArtKat = {93}>} if([Year Week]=weekyear(today()) & num(Week(today()),'00'), OrderRad.NettoBelopp))

If it still doesn't work, could you please post some sample data so we can check the data model?

Re: Set analysis syntax

santharubban — Thu, 30 Jan 2014 19:10:27 GMT

Try this

sum({<%ArtKat = {93},[Year Week] = {"=$(weekyear(today()) & num(Week(today()),'00'))" }>}OrderRad.NettoBelopp)

sum({<%ArtKat = {93},[Year Week] = {'=$(weekyear(today()) & num(Week(today()),'00'))'}>}OrderRad.NettoBelopp)

Re: Set analysis syntax

Thu, 30 Jan 2014 19:19:02 GMT

thank you for your reply.

i have posted the example now.

your suggestions have still not worked, perhaps you could take a look at the application?

best

brad

Re: Re: Set analysis syntax

santharubban — Thu, 30 Jan 2014 19:56:04 GMT

try

sum({<%ArtKat = {93},[Year Week] = {'=$(Variable1)'}>}OrderRad.NettoBelopp)

Variable1 =weekyear(today()) & num(Week(today()),'00')

Re: Set analysis syntax

Thu, 30 Jan 2014 20:07:56 GMT

hello!

thank you for your help!

it seems to ignore the week number, taking the total of all the weeks.

so we should land on 13757, however we land on 45989 in the last Key figure Shipping. so still not working to 100%

Best

Brad

Re: Set analysis syntax

Thu, 30 Jan 2014 20:40:31 GMT

At last

=sum({<%ArtKat = {93}

,[Year Week] = {"=[Year Week]=weekyear(today()) & num(Week(today()),'00')"}>}OrderRad.NettoBelopp)

It seems the dual nature of some fields linked to dates forces to put them inside the expression.