topic Exp in QlikView

Exp

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

Hi all

What does this below statement do ?

Brand= P(Brand) * P(Brand_S),

Thanks

Re: Exp

Siva_Sankar — Thu, 13 Apr 2017 06:04:51 GMT

Hi John,

Your expression wont work. But the logic is intersection in set analysis. You can refer an example here for better understanding. Set analysis intersection

Siva

Re: Exp

smilingjohn — Thu, 13 Apr 2017 06:15:12 GMT

Hi Sivasankar

thanks for the reply the full expression is like this below ... can you please explain this what is it doing ?

=Count( DISTINCT

{

P = {S,O},

Date = {">=$(vPeriod_StartDate)<=$(vPeriod_EndDate)"},

Brand= P(Brand) * P(Brand_S),

Date_P = {"<=$(Max_ClosedLead_Date)"},

}

)

Re: Exp

Anonymous — Thu, 13 Apr 2017 06:35:19 GMT

Hi ,

Here P is used for possible selection,

In set analysis p and e both are helping to possible and exclusion in of the selections.

for all possible Brand is multiplying with Brand_s.

Thanks

Paridhi

Re: Exp

rahulpawarb — Thu, 13 Apr 2017 06:47:21 GMT

Hello John,

Trust that you are doing well!

Said part of the expression will fetch common values from possible Brand and possible Bran_S (i.e. Function P() will give you all possible values whereas * will return records belongs to both the set)

Hope this will help.

Regards!

Rahul

Re: Exp

Siva_Sankar — Thu, 13 Apr 2017 06:55:20 GMT

John Roy,

=Count( DISTINCT // counting the distinct values

{

P = {S,O}, //

Date = {">=$(vPeriod_StartDate)<=$(vPeriod_EndDate)"},

Brand= P(Brand) * P(Brand_S),

Date_P = {"<=$(Max_ClosedLead_Date)"},

}

)

It is actually counting distinct IDs with P field having values S and O

from the vPeriod_StartDate to vPeriod_EndDate for the brands that exist in Brand as well as in Brand_S

with Date_P less than or equal to closedlead date..

Count distinct --counts the distinc IDs

Brand= P(Brand) * P(Brand_S) -- IDs for the Brands that are common in Brand column as well as in Brand_S Column

Actually difficult to explain in words, but to understand better you can post a sample file

Siva

Re: Exp

beck_bakytbek — Thu, 13 Apr 2017 07:02:25 GMT

Hi John,

look at this: https://www.youtube.com/watch?v=4lh-207n2Gk

i hope that helps

beck

Re: Exp

avinashelite — Thu, 13 Apr 2017 07:09:24 GMT

Brand= P(Brand) * P(Brand_S)

Theoretically it will take the common keys between the Brand and Brand_S and use that as the filters for the Brand column and based on this the count will calculated

Re: Exp

Anil_Babu_Samineni — Thu, 13 Apr 2017 07:25:21 GMT

Yes, As Avinash said it will work as Inner Join in DBs