topic Re: Top 3 Direct Sources in QlikView

Top 3 Direct Sources

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I am trying to calculate the Top 3 Direct source

I take one Synthetic Dimension which is Valuelist(1,2,3)

Expression is

If(ValueList(1,2,3) =1,$(vCalcRank(1,P(CompanyTracker))), If(ValueList(1,2,3) = 2, $(vCalcRank(2,P(CompanyTracker))), $(vCalcRank(3,P(CompanyTracker)))))

I am not sure, is that expression is correct or not? Help me

Re: Top 3 Direct Sources

Gysbert_Wassenaar — Wed, 13 Jul 2016 11:14:20 GMT

Please post a small qlikview document that demonstrates the problem.

Re: Top 3 Direct Sources

Anil_Babu_Samineni — Wed, 13 Jul 2016 11:18:40 GMT

Thanks for Attempting.

I don't want any thing. I want to know Explanation about this expression. In that, Variable is below

vCalcRank

----------------

Dual(

Only({1<[Detail]={"=Rank(Count({1<[Source]={'Direct'}, CT = $2, Detail =-{''}>}Candidate))=$1"} >}Detail),

Count({1<[Detail]={"=Rank(Count({1<[Source]={'Direct'}, VT = P(VT), CT = $2, Detail =-{''}>}Candidate))=$1"}, VT = P(VT), CT = $2>}Candidate) / Count({1<[Source]={'Direct'}, VT = P(VT), CT = $2>}Candidate))

What is the use of this?

Re: Top 3 Direct Sources

Gysbert_Wassenaar — Wed, 13 Jul 2016 11:32:55 GMT

How should we know? What is Detail? What is Source? What is Candidate? How are they related? What are you trying to calculate in the first place? And why?

Re: Top 3 Direct Sources

Anil_Babu_Samineni — Wed, 13 Jul 2016 11:51:09 GMT

No, I am asking about flow

Here they are calculating

Dimension is ValuesList(1,2,3)

If(ValueList(1,2,3) =1,$(vCalcRank(1,P(CompanyTracker))), If(ValueList(1,2,3) = 2, $(vCalcRank(2,P(CompanyTracker))), $(vCalcRank(3,P(CompanyTracker)))))

If(Dimensionality() = 1, $(vCalcRank(1,P(CT))))

Same as 2 and 3

And then That variable value is

Dual(

Only({1<[Detail]={"=Rank(Count({1<[Source]={'Direct'}, CT = $2, Detail =-{''}>}Candidate))=$1"} >}Detail),

Here, They are calculating for

Source Field has = {Agency, Direct, Internal, Referral)

Candidate is nothing but Employee Names

VT - Year

CT - Company Names

Might be clear. I Apologize my English