topic Re: Generate values based on field in QlikView

Generate values based on field

help4qv123 — Tue, 20 Mar 2018 07:11:23 GMT

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.

Re: Generate values based on field

Chanty4u — Tue, 20 Mar 2018 07:18:44 GMT

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

istext(field) as text

isnum(field) as number

Re: Generate values based on field

help4qv123 — Tue, 20 Mar 2018 07:26:41 GMT

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.

Re: Generate values based on field

Chanty4u — Tue, 20 Mar 2018 07:27:53 GMT

i dont have access to open

Re: Generate values based on field

Chanty4u — Tue, 20 Mar 2018 07:28:26 GMT

you can try with

keepchar()

purgechar()

Re: Generate values based on field

help4qv123 — Tue, 20 Mar 2018 07:37:16 GMT

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.

Re: Generate values based on field

Chanty4u — Tue, 20 Mar 2018 07:39:52 GMT

may be this ?

concat( field, ',' )

Re: Generate values based on field

help4qv123 — Tue, 20 Mar 2018 09:13:54 GMT

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

Re: Generate values based on field

help4qv123 — Wed, 21 Mar 2018 06:40:29 GMT

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

avinashelite — Wed, 21 Mar 2018 06:50:12 GMT

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

Re: Generate values based on field

avinashelite — Wed, 21 Mar 2018 06:57:02 GMT

Try like this

Table1:

LOAD * INLINE [

ID, A, B

1, a1, a5

2, 4, 9

3, a3, a10

4,2,5

5,AAA,ZZZ

6,a10,a40

7,a*

];

Concatenate

load ID,A,

(KeepChar(A,'0123456789')+IterNo() - 1) as Test,

KeepChar(B,'0123456789') Resident Table1 While IterNo() <= KeepChar(B,'0123456789') - KeepChar(A,'0123456789') + 1 ;

Re: Generate values based on field

help4qv123 — Wed, 21 Mar 2018 07:32:52 GMT

But here my field may have values like A100 or B100. in this case it doesn't work.

or can we do something like. IF i have the lowest and highest value in two separate fields and in third field i have all the values(This table is not linked to the above table).

Then can we bring all the values from lowest to highest from that field?

Re: Generate values based on field

avinashelite — Wed, 21 Mar 2018 07:41:03 GMT

Yes that will work but you need to careful will writing the condition to the combination of the A and B selection in the front end

Re: Generate values based on field

help4qv123 — Wed, 21 Mar 2018 08:01:45 GMT

Yes avinash i have tried this.

It gives ur the numeric value . How can we identify its joint value .

In this case if i select ID 6, then the result i need is a10 to a40.

We got the number 40 as per the logic.

Or is it possible if we have all the values in one field and then we can all the values from a10,a20,a30,a40?

Re: Generate values based on field

avinashelite — Wed, 21 Mar 2018 11:35:43 GMT

as per the above logic your getting the values in the TEST column from 10 to 40 rite ?

Re: Generate values based on field

help4qv123 — Wed, 21 Mar 2018 12:25:31 GMT

Yes. That s fine. The problem is depending on the resulyt i have to mapp it to master data.

If for a Dim Value i have A10. And in master data i have A10,B10,C10 which i need to get.

As we have only numbers (As per your logic). So we have selected 10 , instead of selecting only A10 all the values A10 , B10,C10 will be selected in master data.