topic Re: Setting default values for a Variable in QlikView

Setting default values for a Variable

bashar_f — Mon, 28 Sep 2015 07:47:43 GMT

Hello,

I have an input box that the user populates with salary ranges, if he enters a value, that's great, but if they manually clear values, then the variables becomes null and the bar chart wont work anymore, i need the values to be at least 0 no matter what.

So basically, if the variable becomes = null, then set it to 0, Any help would be greatly appreciated.

Attached is the application.

Regards,

Re: Setting default values for a Variable

Mon, 28 Sep 2015 07:56:27 GMT

Confused about your requirement.

in your shared application what will a user enter in an input box?

Khushboo

Re: Setting default values for a Variable

tresB — Mon, 28 Sep 2015 08:07:03 GMT

Try setting the constraints for the all the variables like:

Inputbox properties->Constraints tab-<Input Constraints-> check Standard : Number

Re: Setting default values for a Variable

bashar_f — Mon, 28 Sep 2015 08:23:23 GMT

Hey tresesco,

Nice one, works great! One more question, you see how there's a listbox that has values like "Range 1 Start - Range 1 End", What do i need to do in order for this listbox to reflect the values I enter in the input box, for example. If i enter in Range 1 Start = 200, and Range 1 End = 1000. is it possible to show "200 - 1000" dynamically in the list box?

Re: Setting default values for a Variable

tresB — Mon, 28 Sep 2015 08:43:06 GMT

May be like attached sample.

PFA

Re: Setting default values for a Variable

bashar_f — Mon, 28 Sep 2015 09:00:49 GMT

Amazing, thanks so much!

Re: Setting default values for a Variable

pratap6699 — Mon, 28 Sep 2015 09:29:52 GMT

yes,, goto document properties-->triggers--> variable triggers--> select vstart-->give fieldname,value='>='&vstart&'<='vend do the same thing for vend..... when we select on field value (200) till end value(1000) it will selected on field listbox automatically