Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

gaurav2017
Contributor II

Write Range & Select in an input box

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,

1 Solution

Accepted Solutions
Employee
Employee

Re: Write Range & Select in an input box

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.

5 Replies
gaurav2017
Contributor II

Re: Write Range & Select in an input box

Anybody please

Employee
Employee

Re: Write Range & Select in an input box

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.

gaurav2017
Contributor II

Re: Write Range & Select in an input box

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,

Employee
Employee

Re: Write Range & Select in an input box

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

gaurav2017
Contributor II

Re: Write Range & Select in an input box

Dear,

Thanks for the reply.