topic Re: Subfield with Set Analysis in QlikView

Subfield with Set Analysis

Anonymous — Thu, 05 Oct 2017 05:36:29 GMT

I have a field called PERMISSIONS,

PERMISSIONS

TENNIS|A|B|C

TENNIS|A|B|C|D

TENNIS|A|B|C|D|E

I have 3 rows in PERMISSIONS,

I want to take only the first row, and display the last text from it

in this case, it is C from the first row and display it in the text object

How can i do that ?

It didn't worked..

Re: Subfield with Set Analysis

el_aprendiz111 — Thu, 05 Oct 2017 16:58:10 GMT

Hi,

=Concat(chr(13) & subfield(PERMISSIONS,'|',2))

Re: Subfield with Set Analysis

Anonymous — Fri, 06 Oct 2017 03:42:32 GMT

Thanks for the help.

PERMISSIONS

TENNIS|A|B|C

TENNIS|A|B|C|D

TENNIS|A|B|C|D|E

I have 3 rows in PERMISSIONS,

I want to take only the first row, and display the last text from it

in this case it is C from the first row and display it in the text object

How can i do that ?

Re: Subfield with Set Analysis

Frank_Hartmann — Fri, 06 Oct 2017 15:56:26 GMT

Maybe like that:

Load *, RowNo() as Row;
Load * INLINE [
PERMISSIONS
TENNIS|A|B|C
TENNIS|A|B|C|D
TENNIS|A|B|C|D|E
];

Textboxexpression:

=right(only({<Row={'1'}>}PERMISSIONS),1)

Re: Subfield with Set Analysis

Peter_Cammaert — Fri, 06 Oct 2017 16:06:16 GMT

What do you mean by "first row"? In a listbox? And what if the sort order is reversed? Do you take the last row?

Re: Subfield with Set Analysis

Peter_Cammaert — Fri, 06 Oct 2017 16:08:56 GMT

If you want the first value from the symbol table of field PERMISSIONS, you can use

=SubField(FieldValue('PERMISSIONS', 1), '|', 4)

but that will depend on the load order of the PERMISSIONS values...

Re: Subfield with Set Analysis

its_anandrjs — Sat, 07 Oct 2017 16:36:50 GMT

Can you check with this in any text object

=Only(SubField(PERMISSIONS,'|',4))

Re: Subfield with Set Analysis

its_anandrjs — Sat, 07 Oct 2017 16:43:17 GMT

You can try this way

LOAD *,

RowNo() AS rid;

LOAD * Inline

[

PERMISSIONS

TENNIS|A|B|C

TENNIS|A|B|C|D

TENNIS|A|B|Z|D|E

];

In text object

=Only( {<Leng={12} >} SubField(PERMISSIONS,'|',4))

Re: Subfield with Set Analysis

Anonymous — Mon, 09 Oct 2017 04:26:00 GMT

I should display the Last text after ' | ', it can be any line.

One row can have any no of '|', but i should display only the last text after ' | '.

And also the row values can be of any length as below

PERMISSIONS

TENNIS|Austraila|Britain|india

TENNIS|AAAA|BB|CCC|DDD

TENNIS|A|B|C|DEF|GE

How can i achieve that ?

Re: Subfield with Set Analysis

antoniotiman — Mon, 09 Oct 2017 14:54:09 GMT

Hi,

may be this

LOAD FirstSortedValue(DISTINCT String,-Count) as MaxString;
LOAD *,SubStringCount(PERMISSIONS,'|') as Count,SubField(PERMISSIONS,'|',-1) as String Inline [
PERMISSIONS
TENNIS|Austraila|Britain|india
TENNIS|AAAA|BB|CCC|DDD
TENNIS|A|B|C|DEF|GE
];

Regards,

Antonio

Re: Subfield with Set Analysis

Peter_Cammaert — Mon, 09 Oct 2017 15:08:18 GMT

Yes you can do that.

Create a listbox with an Expression (instead of a Field Name) like:

=SubField(PERMISSIONS, '|', -1)

The negative third parameter of SubField() tells the function to start parsing from the end instead of the front of the string.