topic Re: Please need urgent reply in QlikView

Please need urgent reply

Mon, 16 Sep 2013 06:38:57 GMT

Hi,

I am using one url to disply records for that using

='http://NA_TextSearch_SV_Report'&'&ReportLimit=' & '$(v_ReportLimit)'

$(v_ReportLimit) - It is variable for limiting the records

And i have a input box with v_ReportLimit for entering records limit manually , I am trying to disply error message for that taking below condition

IsNum($) and $ >= 0 and $ <= 500000 in custom option of constraints tab ,

So while selecting any value between 0 to 500000 it is showing report but my issue is if i don't select any value in the input box it has to disply default 500000 records ,

For that i tried ''if'' condition' in the url level like

='http://NA_TextSearch_SV_Report'&'&ReportLimit=' & 'if(IsNull($(v_ReportLimit)),100000,$(v_ReportLimit))'

But is throwing error ,

It is possible to fix this issue in input box level ?

Please any one help me Is there any other way to fix this .

Thanks,

Ankitha

Re: Please need urgent reply

Gysbert_Wassenaar — Mon, 16 Sep 2013 08:03:02 GMT

Try ='http://NA_TextSearch_SV_Report'&'&ReportLimit=' & alt($(v_ReportLimit), 500000)

Re: Please need urgent reply

Mon, 16 Sep 2013 09:06:21 GMT

Hi Wassenaar,

Thanks for the reply

I have a input box with v_ReportLimit for entering records limit manually , I am trying to disply error message for that taking below condition

IsNum($) and $ >= 0 and $ <= 500000 in custom option of constraints tab ,

So while selecting any value between 0 to 500000 it is showing report but my issue is if i don't select any value in the input box it has to disply default 500000 records

So now changed the url that what you suggest ...that's fine

But i want to achieve it through input box , but now when i select 0 to 500000 then only getting the result , i am trying to select empty value here getting error report that please select 0 to 500000(not able to put it in without value).

Thanks,

Ankitha

Re: Please need urgent reply

Gysbert_Wassenaar — Mon, 16 Sep 2013 09:14:20 GMT

It's not possible to display an error message if the input box is not used. The input box can only display an error message if somebody inputs a value or clicks in the input box and presses the enter key without first entering a value.

If you specify a condition $>=0 and $<=500000 then an 'empty' value will also trigger the error message. But only if the input box is used. If the user doesn't enter anything or presses the escape key after entering a value no error message will be displayed.

Re: Please need urgent reply

Mon, 16 Sep 2013 09:30:09 GMT

Hi Wassenaar,

Again thanks for the reply...

Is there any way to keep input box value in standard position means while giving clear after all filters it should disply 500000 ..

Thanks ,

Ankitha

Re: Please need urgent reply

Gysbert_Wassenaar — Mon, 16 Sep 2013 09:41:59 GMT

I don't understand the problem. Once the variable has a value it cannot be cleared though the input box if you added the constraint in the properties window. Clearing selections won't clear variables. So simply give the variable a value once and you should be done. If you want to reset the value of the variable when you clear the selections you can add a Set Variable action to the OnAnySelect document trigger to check the currentselections and set the value: if(len(getcurrentselections())=0,500000,$(v_ReportLimit))