topic Re: Write Range & Select in an input box in QlikView

Write Range & Select in an input box

gaurav2017 — Thu, 13 Dec 2012 12:43:04 GMT

Hi friends,

I am working with the range selection in an input box. While working I am facing some issue with different formats of value. While selecting "Numerical" values, my logic is working fine but when dealing with other type of formats like "text", My logic is not working. please help frnds.

Look for an attachment below.

Regards,

Re: Write Range & Select in an input box

gaurav2017 — Thu, 13 Dec 2012 14:40:58 GMT

Anybody please

Re: Write Range & Select in an input box

Josh_Good — Sat, 15 Dec 2012 00:17:53 GMT

The only solution I can think of would be to convert the letters into numbers. You could create a new field in the data teh represents the data in numerical forms (using the ORD function) and then make a selection on that field. One the selection is made on the new field you do could a select possible on the text field and unselect the numerical field.

Re: Write Range & Select in an input box

gaurav2017 — Mon, 17 Dec 2012 07:46:06 GMT

Hi Josh,

Thanks a lot..............I am curious....so i am asking a question. If one of the fields "Sel01", "Sel02", "Sel03" would be a Key then i have to put the logic in script for the occurence of it in every load statement or not.

regards,

Re: Write Range & Select in an input box

Josh_Good — Mon, 17 Dec 2012 15:12:37 GMT

Hi,

If all of the uniquie key records exist in one of the tables then you can script the addional field into that table and leave it out of the other table(s).

If have unique key records in more than one table then best practice would be to write your script to get all the unique key records into one table first to avoid creating a synthetic key.

-Josh

Re: Write Range & Select in an input box

gaurav2017 — Wed, 19 Dec 2012 05:47:15 GMT

Dear,

Thanks for the reply.