topic Re: Explain in QlikView

Explain

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

Hi All ,

Can someone explain me the below expression , please

what is happening .

What is Lead_SubCatergory doing and what is Lead_Source ? what doesn {'*'}-... means

num(Count(DISTINCT

{$<

Date = {">=$(StartDate)<=$(EndDate)"},

Dept= P(Dept_R),

Lead_SubCategory={'Internet','Regional','Special Program','Dealer Sourced','Dealer Entered','Third Party'},

Lead_Source={'*'}-{'Showroom','Phone','lmn','Dealer Third Party'},

[Load]={'Phone','Email','Text'}

>} Cost_ID

)),

Regards

John

Anonymous — Thu, 16 Jun 2016 05:09:16 GMT

From your expression:

You are counting distinct Cost_ID which meets the following conditions:

1) Date falls between start & end date

2) All possible department available with regards of your selection like P(Dept_R)

3) Where Lead Subcategory is equal to : Internet','Regional','Special Program','Dealer Sourced','Dealer Entered','Third Party

4) Where Lead Source does not equal to ='Showroom','Phone','lmn','Dealer Third Party'

{'*'} means all the available values of fields

smilingjohn — Thu, 16 Jun 2016 05:22:41 GMT

Thanks Balraj

For your detailed explanation