topic Error in Set Expression in QlikView

Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 06:37:54 GMT

Hello All,

I am Using the following Expression:

=Sum({<[Revenue.Invoice Date] = {$(vCutoffDate)}>} [Revenue.Invoice Amount]/vMillion)

Its returning me an Error: ERROR in SET MODIFIER, ',' or ')' Expected.

Need Help..

Re: Error in Set Expression

jyothish8807 — Mon, 13 Oct 2014 06:40:22 GMT

Hi,

Try this:

=Sum({<[Revenue.Invoice Date] = {'$(=vCutoffDate)'}>} [Revenue.Invoice Amount]/$(=vMillion))

REgards

Re: Error in Set Expression

alexandros17 — Mon, 13 Oct 2014 06:41:45 GMT

is vMillion a variable? If yoe try $(vMillion)

Re: Error in Set Expression

ashfaq_haseeb — Mon, 13 Oct 2014 06:43:29 GMT

Hi,

make sure you have proper date format,

Then try below

=Sum({<[Revenue.Invoice Date] = {'$(=vCutoffDate)'}>} [Revenue.Invoice Amount])/vMillion

=Sum({<[Revenue.Invoice Date] = {'$(=vCutoffDate)'}>} [Revenue.Invoice Amount])/$(vMillion)

Regards

ASHFAQ

Re: Error in Set Expression

Mon, 13 Oct 2014 06:46:37 GMT

Try this,

=Sum({<[Revenue.Invoice Date] = {'$(=vCutoffDate)'}>} [Revenue.Invoice Amount]/vMillion)

Re: Error in Set Expression

stabben23 — Mon, 13 Oct 2014 06:50:03 GMT

If you have sum in your variable then you have to move it outside expression, like Ashfaq shows.

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 06:52:09 GMT

Nope, Its giving me 0, which is not correct.

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 06:52:42 GMT

This is just to convert the value in Millions, Even if I remove this, the problem is the same.

Re: Error in Set Expression

jyothish8807 — Mon, 13 Oct 2014 07:20:46 GMT

Hi Try this:

=Sum({<[Revenue.Invoice Date] = {'$(=vCutoffDate)'}>} [Revenue.Invoice Amount])/$(vMillion)

If you still face issue, then check your variable ina text box and see yhe output:

In text box:

=$(vCutoffDate)

Regards

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 07:24:50 GMT

Hello Jyothish,

=$(vCutoffDate) is giving me -20, I guess there is the problem.

But I am using the same variable to calculate >=Start Date to < CutoffDate which is working fine,

Also used it in >CutoffDate to <=EndDate which is also working fine,

Only = CutoffDate is not working.

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 07:36:56 GMT

Hello GUys Please Help,

Its Ugent,

=$(vCutoffDate) in a text box, is giving me -20, but =vCutoffDate in a text Box is giving me '02-11-11' which is correct. I guess there is the problem.

But I am using the same variable to calculate >=Start Date to < CutoffDate which is working fine,

Also used it in >CutoffDate to <=EndDate which is also working fine,

Only = CutoffDate is not working.

Re: Error in Set Expression

ashfaq_haseeb — Mon, 13 Oct 2014 07:41:00 GMT

Hi,

Can you share sample application to look over.

Regards

ASHFAQ

Re: Error in Set Expression

stabben23 — Mon, 13 Oct 2014 07:47:24 GMT

Try this: {'$(=Date(vCutOffDate))'}...

Re: Error in Set Expression

jyothish8807 — Mon, 13 Oct 2014 07:51:55 GMT

Hi Alkesh,

In your variable module where you have declared the variable, add a = in the begining of the variable declaration

ed:

=Max(Year) instead of max(Year)

Regards

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 07:57:50 GMT

This Variable is entered by the user through an Calender Object.

I already changed the number format in the calender object as Date 'DD-MM-YYYY'

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 07:58:26 GMT

That Would be a little Difficult..Sorry!

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 07:59:28 GMT

NO, The answer is still 0,

Re: Error in Set Expression

ashfaq_haseeb — Mon, 13 Oct 2014 08:01:56 GMT

It is difficult to tell without seeing.

Contact me on skype

my skypeID: ashfaqhaseeb

Regards

ASHFAQ

Re: Error in Set Expression

stabben23 — Mon, 13 Oct 2014 08:02:22 GMT

But you have 'DD-MM-YY' in your variable you says.

Re: Error in Set Expression

alkesh_sharma — Mon, 13 Oct 2014 08:03:48 GMT

I am in Office, Can't connect now...:(