topic STRING in a expression.... how to transform it? in QlikView

STRING in a expression.... how to transform it?

Tue, 20 Dec 2011 08:14:34 GMT

I have a string made in this way:

"14|13|5"

I would like to convert this string by using a condition....

for example: If one of the value is > 10 then transorm it in A else in B:

I would like to have as a result:

"A|A|B"

Is it possible ?

Thanks in advance

STRING in a expression.... how to transform it?

vijay_iitkgp — Tue, 20 Dec 2011 08:23:31 GMT

Is this string have fixed number of "|" ??

Re: STRING in a expression.... how to transform it?

Miguel_Angel_Baeyens — Tue, 20 Dec 2011 08:26:04 GMT

Hi,

Assuming the following script:

LOAD Concat(ValueCheck, '|') AS ValueCheck2;
LOAD If(SubField(Value, '|') > 10, 'A', 'B') AS ValueCheck INLINE [
Value
15|14|3
];

The field ValueCheck2 will store as you want. SubField() will return each part separated by "|", the If() will return "A" or "B", the Concat() in the preceding load will concatenate values "A" and "B" using "|" as separator and store them into a new field called ValueCheck2.

Hope that helps.

Miguel

STRING in a expression.... how to transform it?

Tue, 20 Dec 2011 08:33:52 GMT

This has to be done as en expression of a graph... I cannot use that in a load instruction

STRING in a expression.... how to transform it?

Tue, 20 Dec 2011 08:37:04 GMT

Indeed this the expression made for generating the string:

=concat(distinct round(AGGR(SUM(W_FT_VALORE_NETTO),C_PROVINCIA_FATT)), '|',fieldIndex('C_PROVINCIA_FATT', C_PROVINCIA_FATT))

STRING in a expression.... how to transform it?

vijay_iitkgp — Tue, 20 Dec 2011 08:39:43 GMT

If number of | is fixed (2) then you can use expression:

If(Subfield(Field,'|',1)>10,A,B) &'|'&If(Subfield(Field,'|',2)>10,A,B)&'|&'If(Subfield(Field,'|',3)>10,A,B)

Regards

Vijay

STRING in a expression.... how to transform it?

Tue, 20 Dec 2011 08:43:30 GMT

I am sorry but I don't know the exact number .... I am very unlucky ... I know is a very complicated problem

STRING in a expression.... how to transform it?

Tue, 20 Dec 2011 09:39:57 GMT

What do you think, Macro is the only way to cope with this problem ?

Re: STRING in a expression.... how to transform it?

Miguel_Angel_Baeyens — Tue, 20 Dec 2011 10:22:56 GMT

Hi,

Did you try to use the same expression, but using the conditional instead?

=concat(distinct If(round(AGGR(SUM(W_FT_VALORE_NETTO),C_PROVINCIA_FATT)) > 10, 'A', 'B'), '|',fieldIndex('C_PROVINCIA_FATT', C_PROVINCIA_FATT))

Hope that helps.

Miguel

STRING in a expression.... how to transform it?

Tue, 20 Dec 2011 10:31:34 GMT

Yes that was my first try .... but the concat function makes all difficult:

If I add a if .... it's going to show me a string made up of a number equal to my C_PROVINCIA .... and not just the aggregation made up with the sum. I cannot get why... really. The main problem is the concat function.

STRING in a expression.... how to transform it?

Tue, 20 Dec 2011 10:44:45 GMT

All this stuff ... is to show ... the Amount of sales (or whatever) for each region by using the google api chart ...

I would like to show a gradient geo-chart ....

It's going to be ...very difficult