topic Re: Expression not working in QlikView

Expression not working

Wed, 03 Apr 2013 14:59:06 GMT

Hi, can anyone tell me what i am doing wrong in this expression please? i can't get it working..

sum({<[Reporting Week]={'>=$(vLWRepWeek)<=$(vLWRepWeekEnd)'}>} [Revenue Loss])

Thanks

danielrozental — Wed, 03 Apr 2013 15:43:18 GMT

You should be using double quotes instead of simple quotes.

sum({<[Reporting Week]={">=$(vLWRepWeek)<=$(vLWRepWeekEnd)"}>} [Revenue Loss])

Whenever something isn't working for you try testing with a simpler version, like using a single variable, using a hardcoded value, etc.

Clever_Anjos — Wed, 03 Apr 2013 16:14:22 GMT

I would try using double quotes and intersection

sum({<[Reporting Week]={">=$(vLWRepWeek)"}*{"<=$(vLWRepWeekEnd)"}>} [Revenue Loss])

Wed, 03 Apr 2013 16:18:23 GMT

Hi, thanks for the reply. although that still didnt work.

My variables are :

LWRepWeek

=Date([Reporting Week Start]-7)

LWRepWeekEnd

=Date([Reporting Week End]-1)

and if i look at the variables in a text box i get the correct dates so i know there isnt a problem with the variables.

Thu, 04 Apr 2013 09:42:07 GMT

Hi all, unfortunately i still can't get this working.

I have attached a sample. Would anyone be able to take a look for me please?

Thanks

Gysbert_Wassenaar — Thu, 04 Apr 2013 10:19:12 GMT

You need to use Reporting Date for the comparison and also empty selections in Reporting Week:

sum({<[Reporting Week]=, [Reporting Date]={'>=$(=date($(vLWRepWeek)))<=$(=date($(vLWRepWeekEnd)))'},[Reason Group] = {'Upgrade'}>} [Revenue Loss])

Fri, 05 Apr 2013 13:46:58 GMT

Thanks Gysbert