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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Feature Request: Variable constraints should be applicable regardless of input method

Hi Everyone,

I’m not the first to notice this, but I want to understand if it’s impacting anyone else in the community:

Did you know that if you place a constraint on a variable that the constraint actually only applies to the variable when exposed in an input box? If you use a calendar object to set a date variable (for example), the constraint is completely ignored.

QlikView support has deemed that this is functionality as designed. I have raised this as a feature request.

Do you agree that variable constraints should be respected regardless of input method?

Please post comments below.

Thanks!

8 Replies
Miguel_Angel_Baeyens

Hi,

Place an Idea for that. I think it's a good idea and that helps R&D people to check which features are requested, and why.

Miguel

Not applicable
Author

Awesome! I had no idea that ideas even existed. I'll add it there.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I know how to define a constraint on an Input Box, but not a variable.

Where do you define a constraint on a Variable?

Thanks,

Rob

Not applicable
Author

I have always set constraints in document properties, under the variables tab. I've always assumed that I was constraining the variable. I see now that where I was placing them says INPUT Contraints. and these constraints are inhereted by INPUT BOXES, but Calendar objects do not have such input constraints.

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks. Can't believe I never noticed that!

-Rob

christian77
Partner - Specialist
Partner - Specialist

Hi.

I have 2 variables. vPlazoOperacion01, and vPlazoOperacion02.

vPlazoOperacion01 must be greater than vPlazoOperacion02.

I have tried some clauses but none works.

Do you know the correct syntax?

Thanks.

constraints01.png

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

In the Custom Constraint expression, use "$" to refer to the input value being tested. So your constraint for vPlazoOperacion01 would be

     =$ >vPlazoOperacion02

-Rob

http://masterssummit.com

http://robwunderlich.com

christian77
Partner - Specialist
Partner - Specialist

Thank you!

I couldn't figure that syntax out. It must be in the manual.

I also see that a constraint is valid for the whole document even when I try to change it in the variable overview.

Christian.