Best Lead Provider

[#1]

Hi Guyys , I m New in qlikview.. i m doing learning Qlikview.. i have a question kinldy help me..

i have to column.. i want to Know Who is the Lead Provider.. and I want to show a Answer in text..so how can i do..

i m able to find with Chart.. Using LeadProviderId as Dimension and Count(LeadId) as Expression.. but how to show in Text..

kinldy help me

[awhitfield]

Hi Brijesh,

if you are using a straight chart for example, Properties > Dimension Limits > set  as shown below:

HTH Andy

[#3]

but i want to show a Answer in Text

BEST Lead Provider ---- Text Caption

LP005 --- Text Value

[anbu1984]

Try this expr in Text box

=FirstSortedValue(LeadProvider_Id,-Aggr(Count(Lead_Id),LeadProvider_Id))

[sushil353]

Hi,

Create a Text Box

and write the expression = LeadProviderId

When u select the LeadId then you will get LeadProviderId in Text box

HTH

sushil

[Peter_Cammaert]

Put this in a text box. Let me know what happens.

='BEST Lead Provider' & chr(10) & IF (aggr(Rank(Count(LeadId)), LeadProviderId) = 1, LeadProviderId)

[awhitfield · Accepted solution]

Hi again,

see the attached

Andy

[anbu1984]

=MaxString( IF (aggr(Rank(Count(Lead_Id)), LeadProvider_Id) = 1, LeadProvider_Id))

[Peter_Cammaert]

Right, or even better:

=Concat( IF (aggr(Rank(Count(Lead_Id)), LeadProvider_Id) = 1, LeadProvider_Id)), ',')

If there are multiple gold medalists (a tie), we should show all of them.

[#10]

Thanks Andrew..Thanks for Ur Support