Filter in Deski

building reports desktopintelligence
1

Hi All,

I need to apply fillter which is matching word for example

i have user prompt they can select RTP and MONTH CLOSE

07 RTP 07 MONTH CLOSE
08 RTP 08 MONTH CLOSE
09 RTP 09 MONTH CLOSE
10 RTP 10 MONTH CLOSE

i created two tabs one for RTP data another for MONTH CLOSE.

first tab i am filtering to dispaly only RTP data

match (,"*RTP") but it displaying both in each tab.

Please help me to filter .

Thank you,
Ravek

ravek (BOB member since 2006-08-03)

2

hi

is this displayed in a single variable?

nickie :us: (BOB member since 2010-02-16)

3

Hi,

Yes, All the data in single variable

07 RTP
07 MONTH CLOSE
08 RTP
08 MONTH CLOSE
09 RTP
09 MONTH CLOSE
10 RTP
10 MONTH CLOSE

Thank you,
Ravek

ravek (BOB member since 2006-08-03)

4

Did you apply a filter after getting the result of Match() function?

Jansi :india: (BOB member since 2008-05-12)

5

Hi Jansi,

I can apply the filter but if user select some other RTP then i won’t display the data right

example

if i filter on 10 RTP then user select 07 RTP, i won’t disply data right

i would like to write a filter like this ‘%RTP’ mean dinamic

How i can i apply above one. Please let me know

Thank you,
Ravek

ravek (BOB member since 2006-08-03)

6

Hi

If you really wanted to filter data based on ‘RTP’ or ‘Month close’, i would suggest to follow the below.

Create a prompt with matches patter for user input and it should either RTP or Month close’ and then you can display the data accordingly.
If the user input RTP, then they can see only RTP data and vice versa.

Regards
Siva.M

looksmee :uk: (BOB member since 2006-02-08)

7

Apply a filter by defining it, not selecting values.

So, in the filter dialogue box, press define, then put a formula like this in

=Match(<YourField)> ,“RTP”)

This will select any value with RTP within it.

Simon

psaw :uk: (BOB member since 2010-06-11)

8

Hi Psaw,

That formula is not working because i am trying to apply filter on section. Than you for your reply.

Thanks,
ravek.

ravek (BOB member since 2006-08-03)

9

Ravek

Your first post said that you want RTP in one tab and Month Close in another. In that case you set a global filter in each tab or report, one matching RTP and one MONTH

If you want to use RTP and Month Close to be sections within one report then I suggest you define a new variable with a formula something like
=if (Match(<YourField)> ,“RTP”)) then “RTP” else “MC”
and use that variable as the master for a section.

Simon

psaw :uk: (BOB member since 2010-06-11)

10

Hi Simon,

Yes, i have two tabs my users want fist tab should disply only RTP data.

second should be Month close.

if i create this =if (Match(<YourField)> ,“RTP”)) then “RTP” else “MC”

it will disply all the data in in first tab.

i want display only RTP data and as section in first tab.

Plase let me know if you need more information.

Thanks,
ravek.

ravek (BOB member since 2006-08-03)

11

Right clic / Format Filter / Global / Add /
Define /

=Match(<Your Field>,"*RTP*")

do the same thing for the other tab

~ Yann ~ :fr: (BOB member since 2007-09-11)