topic Re: Showing Top 10 Values in Separate Textboxes in QlikView

Showing Top 10 Values in Separate Textboxes

Fri, 22 Nov 2013 12:15:16 GMT

Hi, I have a datatable that consists of 3 separate areas and corresponding dates. I need to show the top 10 comments for each area in 10 separate textboxes.

My Datatable look like :

The 10 texboxes should only be populated when the user has selected an Area from ListBox.

So, Im guessing that the set analaysis for Texbox 1 should resemble something like :

Only when a Distinct Area has been selected show Comment where the Order_Number = 1

TexBox 2 : Only when a Distinct Area has been selected show Comment where the Order_Number = 2

and so on for 10 textboxes

Hope someone can advise?

Thanks,

Tom

Re: Showing Top 10 Values in Separate Textboxes

Nicole-Smith — Fri, 22 Nov 2013 13:38:26 GMT

For textbox 1:

=if(GetSelectedCount(Area)=1, only({<order_number={1}>}Comment))

For textbox 2:

=if(GetSelectedCount(Area)=1, only({<order_number={2}>}Comment))

and etc.

Re: Showing Top 10 Values in Separate Textboxes

Fri, 22 Nov 2013 13:43:10 GMT

perfect thank you!