Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

help4qv123
Contributor II

Generate values based on field

Hello Experts,

I need some help :

Here is the senario. I have two fields where one field has a starting value and another has its end value.

The fields may have numeric, alphabetic, alphanumeric. (eg: 0,1,2,a11,aaa)

It works for the numbers , but not with others. Is it possible ?

I have attached the sample QVW with an example.

Tags (1)
15 Replies
Chanty4u
Esteemed Contributor III

Re: Generate values based on field

im unable to open your qvw.

but what is your expectation?  you want seperate field for text and numeric?

if yes try this

load *,

......

text(field) as Text,

num(field) as number

or

istext(field) as text

isnum(field) as number

help4qv123
Contributor II

Re: Generate values based on field

no in a separate field i want the values which are in between those.

If you could open the application you can know it easily.

Chanty4u
Esteemed Contributor III

Re: Generate values based on field

i dont have access to open

Chanty4u
Esteemed Contributor III

Re: Generate values based on field

you can try with

keepchar()

purgechar()

help4qv123
Contributor II

Re: Generate values based on field

no bro. These function are just to display. But in my senario i have two fields and it when i select a value some other value is assosiated in another field.

Example: field1 value is A110 and field 2 value is A130

then i have to generate an another field which given me all the values between A110,A111,A112.....A130.

Same if the field1 value is A1* then all the values which start with A1 (A110,A111,A112...) should be displayed.

Chanty4u
Esteemed Contributor III

Re: Generate values based on field

may be this ?

concat( field, ',' )

help4qv123
Contributor II

Re: Generate values based on field

No. it just give all the values of the other field in one.

Highlighted
help4qv123
Contributor II

Re: Generate values based on field

sunny talwar‌

sunnyt‌

gysbert wassenaar‌

stalwar1

gysbert‌

jonathan poole‌

jagan mohan rao applo‌

henric‌

Hello All,

Could you please help me on this issue.

Re: Generate values based on field

You cannot make an comparison on the alpha numeric values that won't give the desired results
try like this :

In the script create a new filed by keeping only the numbers i.e if you have the values like A100 it should be 100

then while making the comparison use the other filed but while displaying use the actual field this way you could handle this requirement