Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
alkesh_sharma
Creator III
Creator III

Error in Set Expression

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..

27 Replies
alkesh_sharma
Creator III
Creator III
Author

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.

ashfaq_haseeb
Champion III
Champion III

Hi,

Can you share sample application to look over.

Regards

ASHFAQ

stabben23
Partner - Master
Partner - Master

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

jyothish8807
Master II
Master II

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

KC

Best Regards,
KC
alkesh_sharma
Creator III
Creator III
Author

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'

alkesh_sharma
Creator III
Creator III
Author

That Would be a little Difficult..Sorry!

alkesh_sharma
Creator III
Creator III
Author

NO, The answer is still 0,

ashfaq_haseeb
Champion III
Champion III

It is difficult to tell without seeing.

Contact me on skype

my skypeID: ashfaqhaseeb

Regards

ASHFAQ

stabben23
Partner - Master
Partner - Master

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

alkesh_sharma
Creator III
Creator III
Author

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