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