Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
My dimension is [Defect Type]
I want to show Defect Cause in textbox (Top 3) Note : Top 3 Defect Cause I am deciding based on defect count for each [Defect Type] and Defect Cause.
So my [Defect Type] are (Testing, Requirement, Development etc. )
So for each [Defect Type] I should show three text boxes
ex . for Requirement
Textbox1 should show 'CR-Change/Missing Requirement
Textbox2 should show 'NC- Not clear Requirement
Textbox3 should be black as I dont have third value(record)
Note : This should work without any selection
Hope I am clear on my requirement.
Also attaching my sample application
Thanks
BKC
Hi Piet,
Sorry to disturb you again.
Above expression is working fine in text box but when I am using same expression in listbox ... it not working.
Could you please help me on this .
Thanks
BKC
I'm assuming you want a listbox displaying the top 3 Defect causes for a specific type?
In a listbox you always select values from a field, not just some strings. The above solution results in a string and can not be used in a listbox. You can use an expression to limit the values from a field and display those in a listbox. In a listbox choose expression instead of a field and use something like
=Aggr(if(Rank([Defect Count])<4 and [Defect Type]='Requirements',[Defect Cause]),[Defect Cause])
It uses the rank function, see help and also attached example might help (see top 10 calculated listbox)
Thanks Piet