topic Re: Best Lead Provider in QlikView

Best Lead Provider

Wed, 20 May 2015 10:54:03 GMT

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

Re: Best Lead Provider

awhitfield — Wed, 20 May 2015 11:08:00 GMT

Hi Brijesh,

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

HTH Andy

Re: Best Lead Provider

Wed, 20 May 2015 11:40:48 GMT

but i want to show a Answer in Text

BEST Lead Provider ---- Text Caption

LP005 --- Text Value

Re: Best Lead Provider

anbu1984 — Wed, 20 May 2015 11:44:25 GMT

Try this expr in Text box

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

Re: Best Lead Provider

sushil353 — Wed, 20 May 2015 11:45:38 GMT

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

Re: Best Lead Provider

Peter_Cammaert — Wed, 20 May 2015 11:49:47 GMT

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

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

Re: Best Lead Provider

awhitfield — Wed, 20 May 2015 11:59:36 GMT

Hi again,

see the attached

Andy

Re: Best Lead Provider

anbu1984 — Wed, 20 May 2015 12:02:43 GMT

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

Re: Best Lead Provider

Peter_Cammaert — Wed, 20 May 2015 12:08:53 GMT

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.

Re: Best Lead Provider

Wed, 20 May 2015 12:23:26 GMT

Thanks Andrew..Thanks for Ur Support

Re: Best Lead Provider

awhitfield — Wed, 20 May 2015 12:56:51 GMT

No problem, glad to help

Andy