Displaying report filter

[Former Member]

Hi,

I'm using a "Simple Slider" type input control where it has 4 values. I want to display the report filter of the dimension that has been chosen, in the report. May i pl know the query for the same?

[Former Member · Accepted solution]

Hi Giri,

You can go for following formula:

=reportfiltersummary()

Thanks,

Swapnil

[Former Member · Accepted solution]

I tried; but it says #COMPUTATION. Seems to be an error. Kindly do the needful.

[Former Member · Accepted solution]

Hi Giri,

You can try following formula:

=ReportFilter(object)

Thanks,
Swapnil

[former_member211423 · Accepted solution]

Hi Giri,

Please use =ReportFilter([Dimension object]) and

Regards

Sheetal Sharma

[Former Member · Accepted solution]

Hi Swapnil / Sheetal,

In fact, the first one i tried was with ReportFilter([Dim.Object]) only. It was displaying the value as 1, as 1 value has been selected.

In my simple slider input control, i'd given 10, 15 & 20 (3 values) for the user to look at the report either Top 10 / Top 15 / Top 20 products...

I'm in need of that value not the count... Kindly do the needful.

[Former Member · Accepted solution]

Hi Giri,

You can simple write function

= count(primary object on which you are applying rank;all)

Thanks,

Swapnil

[Former Member · Accepted solution]

Sorry. Not OK still.

[Former Member · Accepted solution]

what is your actual requirement

Can you please attach a screen shot and explain me.

Thanks,

Swapni,

[Former Member · Accepted solution]

By using Simple slider input control, the user will look at the defectwise Top 5 or 10 or 15 or 20 variants (products). According to user's selection of 'N' value, the sheet title need to get changed, like:

If the user selects N as 5; Sheet title should display: Defectwise Top 5 variants

If the user selects N as 10; Sheet title should display: Defectwise Top 10 variants

If the user selects N as 15; Sheet title should display: Defectwise Top 15 variants

If the user selects N as 20; Sheet title should display: Defectwise Top 20 variants

I hope you can make out with the above image & illustration.

[Former Member · Accepted solution]

Hi Giri,

I understood now.

Can you please help me out with the formula you are using for input control.

I mean tell me formula which you have assigned to input control

Thanks,

Swapnil

[Former Member · Accepted solution]

Hi Swapnil,

First, let me thank you for getting into my requirement & the inclination you show to resolve my problem.

Well, i learnt from the link you sent yesterday & created the input control like this way:

Step - 1:

New variable [Rank_Defects] created using the variable editor window.

(All_DefectQty is a measure).

Step - 2:

I created an input control - Simple slider for this new variable as shown:

Step - 3:

I had created the Dependencies for the input control as shown:

This is what i've done.

Then, i wanted to display the user selection and attempted the following formulae options (as you suggested):

="Defectwise "+ReportFilter([Rank_Defects])+" variants"

="Defectwise "+ReportFilterSummary([Rank_Defects])+" variants"

="Defectwise "+Count([Rank_Defects];All)+" variants"

None of the above worked, as you aware!

Pl do the needful.

Regards,

Giri

[Former Member · Accepted solution]

hi Swapnil,

                 I am also waiting for this solution . please share with clear example

Regards

Dinesh

[Former Member · Accepted solution]

just drag blank cell and apply formula

=count(All_DefectQty)

Check this formula values by selecting different values in input control and let me know.

Thanks,

Swapnil

[Former Member · Accepted solution]

No effect...

Regards,

Giri

[Former Member · Accepted solution]

Hi Giri,

Is your input control selection change your report?

Like if you select top 5 then it is showing top 5 defects properly?

Thanks,

Swapnil

[Former Member · Accepted solution]

Yes, for sure..

[Former Member · Accepted solution]

Just try following options as I don't have software right now at my system.

In blank cell,

=  [Rank_Defects]

[Former Member · Accepted solution]

Doesn't work. I still read 1 for all the input values...

[former_member201488 · Accepted solution]

I guess this is because your measure is a ranking, and a ranking needs a context?

One way to derive the number you want is to parse the results of your ReportFilterSummary() function to see where it (the number) occurs, then use some Substr and Pos ju-ju to pull it out.

The picture below shows a basic example, but you get the idea; just whack a reportfiltersummary() function on your report and watch where the number changes when you modify the input control. If you need help with deriving it from this string just post back.

HTH

NMG

[Former Member · Accepted solution]

Hi Neil,

Need further help on this....

[former_member201488 · Accepted solution]

You might want to post the output of your reportfiltersummary() function then

[Former Member · Accepted solution]

Hi Neil,

Here is the output what i obtained by calling the function =ReportFilterSummary():

Selected value = 5 (simple slider IC)

*** Filter on Report Synopsis_Sales_and_Returns  ***

Filter on Block SKU:
Ranking Filter:Top 10 SKU Based On Sales Qty  (Count)

*** Filter on Report Defects_Analysis  ***

Filter on Block defect_chrt Result:
Assly New Defectgroup Is Not Null
Filter on Block defect Result:
All_Defectqty Is Not Null
Filter on Block Region Result:
All_Defectqty Is Not Null
Filter on Block Region_Chart Result:
Assly New Defectgroup Is Not Null
Filter on Block bg Result:
All_Defectqty Is Not Null
Filter on Block plant Result:
All_Defectqty Is Not Null

*** Filter on Report Top N Variant Defect  ***

Global Report Filters:
Brand Group Not In List { TOMMY HILFIGER, HUGO BOSS }
Filter on Block plating_defect:

(
Assly New Defectgroup In List { PLATING DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block battery_defect:

(
Assly New Defectgroup In List { BATTERY DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block movt_defect:

(
Assly New Defectgroup In List { MOVEMENT DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block strap_defect:

(
Assly New Defectgroup In List { STRAP DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block case_defect:

(
Assly New Defectgroup In List { CASE DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block assly_defect:

(
Assly New Defectgroup In List { ASSEMBLY DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block dial_defect:

(
Assly New Defectgroup In List { DIAL DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block mg_defect:

(
Assly New Defectgroup In List { MG DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block crown_defect:

(
Assly New Defectgroup In List { CROWN DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block wrr_defect:

(
Assly New Defectgroup In List { WRR }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block pgd_defect:

(
Assly New Defectgroup In List { PGD DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block hands_defect:

(
Assly New Defectgroup In List { HANDS DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)
Filter on Block bc_defect:

(
Assly New Defectgroup In List { BC DEFECT }
)
AND
(
Rank_Defects Less than or Equal to 5
)

*** Filter on Report Top selling variants defects  ***

Filter on Block SKU:
Ranking Filter:Top 10  SKU Based On Sales Qty  (Count)
Filter on Block SKU_IC:
SKU Equal NE1474SM01
Ranking Filter:Top 1  SKU Based On Sales Qty  (Count)

Note to Mr. NEIL: I’ve four sheets in this report. When I call ReportFilterSummary() function into the third sheet, which I’m talking about, it brings the above lengthier output including the summary for all the other three sheets. Hence, to avoid confusion to you, I’d applied light color font to the output of those 3 sheets.

Kindly get back if you need clarifications on my stuff…

Regards,

Giri. K

[former_member201488 · Accepted solution]

The method is pretty much the same; use the POS function in tandem with Reportfiltersummary() to deduce where in the Reportfiltersummary() string the Rank_Defects Less than or Equal to text appears:

=Pos(ReportFilterSummary();"Rank_Defects Less than or Equal to")

Once you know this, you need to add the length of this string to it (which is 34 characters, but add one for the following space, so 35). Finally, put this all into a Substr function and wrap in a Trim function to remove any superfluous spaces:

=Trim(Substr(ReportFilterSummary();Pos(ReportFilterSummary();"Rank_Defects Less than or Equal to")+35;2))

HTH

NMG

[Former Member · Accepted solution]

Hi Neil,

Thanks a lot! My problem is resolved.

Regards,

Giri. K

[Former Member · Accepted solution]

Hi Giri,

Would you please share solution with an clear example .because i am also waiting to get that issuse.

Regards

Dinesh

[Former Member · Accepted solution]

Hi Dinesh,

I hope you understood my requirement clearly!

I have a simple slider type input control for my variable [Rank_Defects], and it created by using the following function:

[Rank_Defects] = Rank([All_DefectQty]).

When my user opts Top 5 or Top 10 products, i want to display the same in my report body too. For this, first he asked me to create a blank cell & apply the formula: =ReportFilterSummary() and share the output of the cell. I did the same.

Having seen my output, he extracted the number (5 or 10) from the output by applying - Trim, Substr & Pos functions. Thus it solved my problem.

I hope you understood now!

Regards,

Giri. K

[Former Member · Accepted solution]

i know ur requirement . my problem is how you wrote condition for getting promped  are slider value  on top

Regards

Dinesh

[Former Member · Accepted solution]

Hi Neil,

When i apply the same Trim...Substr...ReportFilterSummary().... formula to an input control on a dimension using a "Radio button" type, it is not working. May i know the reason please?

[former_member201488 · Accepted solution]

Please provide a bit more information - what you're trying to do, example data, screenshots, etc.

[Former Member · Accepted solution]

Hi,

Let me elaborate my question:

In the same report that we discussed last month, i have another sheet, where i have kept the following dimensions as input controls:

1. Assly New Defectgroup - 'Radio button' type input control

2. Calibre - 'Entry field' type input control

3. Brand - 'Combo box' type input control

4. Cluster - 'Combo box' type input control

Here is the screen shot of the same:

I want to display the selected value under each of the above 4 dimensions in the report body. Kindly support me in writing the query for each.

Please find below the output of "ReportFilterSummary()" function:

*** Filter on Report Defects_Analysis  ***

Filter on Block Defects Tab:
All_Defectqty Is Not Null
Filter on Block plant Result:
All_Defectqty Is Not Null
Filter on Block Defects Pareto:
All_Defectqty Is Not Null
Filter on Block Calibre Tab:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Assly New Defectgroup Equal MOVEMENT DEFECT
)
Ranking Filter:Top 5  Assly Calibre Based On Defect Qty (Count)
Filter on Block Calibre Pareto:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Assly New Defectgroup Equal MOVEMENT DEFECT
)
Ranking Filter:Top 5  Assly Calibre Based On Defect Qty (Count)
Filter on Block Brands Tab:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Brand Group Is Not Null
)
Ranking Filter:Top 5  Brand Group Based On Defect Qty (Count)
Filter on Block Brands Pareto:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Brand Group Is Not Null
)
Ranking Filter:Top 5  Based On Defect Qty  (Count)
Filter on Block Clusters Tab:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Brand Group Is Not Null
)
Ranking Filter:Top 5  Cluster Based On Defect Qty (Count)
Filter on Block Clusters Pareto:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Brand Group Is Not Null
)
Ranking Filter:Top 5  Cluster Based On Defect Qty (Count)
Filter on Block Variants Tab:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Brand Group Is Not Null
)
Ranking Filter:Top 5  SKU Based On Defect Qty  (Count)
Filter on Block Variants Pareto:

(
All_Defectqty Is Not Null
)
AND
(
Assly Calibre Is Not Null
)
AND
(
Brand Group Is Not Null
)
Ranking Filter:Top 5  SKU Based On Defect Qty  (Count)

[former_member201488 · Accepted solution]

I would have thought that you can use a simple =reportfilter([Dimension]) for the Combo boxes, and use the mechanism we discussed above to return any values supplied by an entry field (by parsing the reportfiltersummary() function).

I'm afraid I can't write these for you; all of the information you should need is in this thread. If you get any problems, by all means post back.

NMG