You are not logged in.

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

alfredsampl

Intermediate

  • "alfredsampl" is male
  • "alfredsampl" started this thread

Posts: 5

Date of registration: Jan 17th 2012

Location: Wien

  • Send private message

1

Tuesday, January 17th 2012, 1:43pm

Filter defined elements for dimension in subset

Hi everyone!

We just wondered about whether there is a way to exclude specific elements in a palo excel subset.
Of course, one can use TFILTER referring to a predefined variable (range). Then we get exactly those results, we want to eliminate from our subset result.

For example:
Dimension DATE on a daily basis
We want to show all values on a daily basis except 1 predefined date (let's say: 2012.01.06).

Has anybody found a way how to use TFILTER <> argument?

Thank you very much!


br, Alfred
__________________________________________
Vector SW DV GmbH
Ernst-Melchior-Gasse 20
1020 Wien / Austria
fon: +43 1 216 50 40 - 0
fax: +43 1 216 50 40 - 50
UID: ATU15116602
FB: 99492m
Firmenbuchgericht: Handelsgericht Wien
Besuchen Sie uns / visit us at http://www.vector.eu
__________________________________________

Posts: 368

Date of registration: Dec 2nd 2009

Hobbies: I'll swallow your soul! I'll swallow your soul!I 'll swallow your soul!

  • Send private message

2

Tuesday, January 17th 2012, 7:00pm

Hi,

yes, using a regular expression in your TFILTER criteria. For instance, if I want to exclude "Sweden" from the Regions dimension:
^(?!Sweden)

be sure to check the "PERL regular expression" option

here the complete function:=PALO.SUBSET("localhost/Demo";"Regions";1;;;PALO.TFILTER({"^(?!Sweden)"};TRUE);;;;PALO.SORT(1;0;;0;;0;1))

does it comply your need ?
laloune

"A problem worthy of attack proves its worth by fighting back." Piet Hein

tish1

Sage

Posts: 829

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

3

Tuesday, January 17th 2012, 9:16pm

Hi,

what filter would I have to use to remove all elements ending at '_direct' from a subset?

Regards.

alfredsampl

Intermediate

  • "alfredsampl" is male
  • "alfredsampl" started this thread

Posts: 5

Date of registration: Jan 17th 2012

Location: Wien

  • Send private message

4

Wednesday, January 18th 2012, 9:39am

Hello!

Thank you Laloune for your answer! That's it.

@tish: PALO.TFILTER({"(_direkt)$"};WAHR)


br, Alfred
__________________________________________
Vector SW DV GmbH
Ernst-Melchior-Gasse 20
1020 Wien / Austria
fon: +43 1 216 50 40 - 0
fax: +43 1 216 50 40 - 50
UID: ATU15116602
FB: 99492m
Firmenbuchgericht: Handelsgericht Wien
Besuchen Sie uns / visit us at http://www.vector.eu
__________________________________________

Posts: 368

Date of registration: Dec 2nd 2009

Hobbies: I'll swallow your soul! I'll swallow your soul!I 'll swallow your soul!

  • Send private message

5

Wednesday, January 18th 2012, 12:10pm

you're welcome.

there was certainly more simple (I'm no regexp crack)

more info concerning regexp you can find on the internet (especially regexp testers)
laloune

"A problem worthy of attack proves its worth by fighting back." Piet Hein

tish1

Sage

Posts: 829

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

olapboy

Intermediate

  • "olapboy" is male

Posts: 11

Date of registration: Dec 11th 2007

Hobbies: molap

  • Send private message

7

Friday, March 23rd 2012, 7:03pm

Hi, regexp scientists,

I'm trying to filter a dimension into a subset with regexp. I never find out how can I embed the regexp filters.

First I have to select the elements begining with "p" followed by 12 digits and some string e.g. ".baKR102"
The regexp
p[0-9]{12}\.baKR102$
returns fine the list what I wanted.

From this result I have to exclude some elements begining with unwanted strings e.g.: p2376 or p290014 or p301.
The expression:
^(?!p2376|p290014|p301) makes it perfect for the whole dimension, but how can I apply it for the result above?

Thank you for your help.
regards,

Attila

This post has been edited 2 times, last edit by "olapboy" (Mar 28th 2012, 6:18pm)


olapboy

Intermediate

  • "olapboy" is male

Posts: 11

Date of registration: Dec 11th 2007

Hobbies: molap

  • Send private message

8

Sunday, March 25th 2012, 12:08am

This is not an inordinately useful answer. ?(

Could anyone help me if indeed?
regards,

Attila

This post has been edited 1 times, last edit by "olapboy" (Mar 28th 2012, 6:04pm)


Similar threads

Used tags

Subset, TFILFTER

Rate this thread