You are not logged in.

Subset - Palo.DFilter

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.

Xpresson

Sage

  • "Xpresson" started this thread

Posts: 122

Date of registration: Aug 1st 2007

  • Send private message

1

Thursday, November 6th 2008, 6:29am

Subset - Palo.DFilter

Hi,

I am looking at the Palo Manual page 319 and I am looking at the function
Palo.Dfilter.

I can see the formula
Palo.Dfilter(Palo.Subcube(), {">",300000},10)

which stands for filter for top 10 items greater than 300,000

Is it possible to change
{">",300000}

so that it filters between 50,000 and 300,000

ie. I want top 10 items that are greater than 50,000 but lower than 300,000

On a side note, is it possible to do bottom 10?

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

2

Thursday, November 6th 2008, 9:26am

As you can see in the Subset Editor, it's possible to give two operators for the subcube: {">",300000,"<",500000}

I'm not sure wether it is possible to select the bottom 5 or so straight; it might possible to build a subset like that, but there isn't a direct parameter for it.

Xpresson

Sage

  • "Xpresson" started this thread

Posts: 122

Date of registration: Aug 1st 2007

  • Send private message

3

Thursday, November 6th 2008, 11:07am

Hi Dom,

Thank you very much for the prompt response.

You are a life saver!

Regards,

Jimmy

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

4

Thursday, November 6th 2008, 12:27pm

Regarding your side note: it is possible to retrieve the bottom five using the HFILTER and SORT. You use the DFILTER to enable sorting by values; in SORT, you sort the subset by value in reverse order, and finally, using the revolve argument of hfilter, you only retrieve the first (=> last) 5 elements of the subset.
A colleague of mine built an example for this method which you will find attached.
dominik_l has attached the following file:

Xpresson

Sage

  • "Xpresson" started this thread

Posts: 122

Date of registration: Aug 1st 2007

  • Send private message

5

Thursday, November 6th 2008, 1:14pm

Hi Dominik,

Thank you very much for the below! I never would have got to the answer in a million years!!! I really appreciate your help.

I just have one more question......

Is it possible to filter Subset on Subset? For example

I have 2 dimensions,

Dimension 1 = 1, 2, 3
Dimension 2 = 1, 2, 3

I write a rule to make it a multipllication table

1 2 3
1 1 2 3
2 2 4 6
3 3 6 9

Is it possible for me to search for the "data points" that meets a certain criteria? ie.
if I want to search for any data value = 6, it will return me the elements 2,3 and 3, 2. or
if I search for data value = 2, it will return me the elements 1,2 or 2,1 or
if I search for data value = 4, it will return me the elements 4,4

So it is like a "Double Subset". If the answer is yes, can I go and search for "triple subset"?

I promise that this is the last question!

Xpresson

Sage

  • "Xpresson" started this thread

Posts: 122

Date of registration: Aug 1st 2007

  • Send private message

6

Thursday, November 6th 2008, 1:27pm

Actually......

Don't worry about it. I should have thought about the export function!

Thanks heaps for your help so far!

Can the paste view function use the same filters as export?

ie. instead of exporting, I get it in paste view?

dominik_l

Jedox Team

  • "dominik_l" is male

Posts: 344

Date of registration: May 7th 2008

Location: Freiburg / Germany

  • Send private message

7

Thursday, November 6th 2008, 1:59pm

Quoted

Originally posted by Xpresson
Can the paste view function use the same filters as export?

ie. instead of exporting, I get it in paste view?

No, the only filter here is zero suppression. What you might try is using globally stored subsets that filter for a specific value (DFILTER). Just as during the export, you define a subcube and then give some operators (e.g., = 6). Keep in mind that you may pass a cell reference instead of a fixed value.
Rate this thread