Set analysis without selection

[Anonymous]

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

[Anonymous]

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

[stigchel]

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)

[Anonymous]

Thanks Piet