on 04-06-2015 11:07 AM
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?
Hi Giri,
You can go for following formula:
=reportfiltersummary()
Thanks,
Swapnil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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.
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
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
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
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
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
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)
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
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.