Qlikview Notes

Only({<ZONE={‘A’}>} ZONE)
=count( {<code_t1=p([code_t2])>} DISTINCT id_t1)
=count(DISTINCT if(code_t1=code_t2, id_t1))

Count(DISTINCT {<sfdc_account_id = {‘*’}>} [account_uuid ])
count distinct only when sfdc_account_id is NOT NULL.
Count({$<OrderID = {“=Hour(ELS.FirstSubmission) >= Hour (MakeTime(18))”}>} OrderID )
Count({$<Hour_ELS.FirstSubmission = {“>=$(=Hour(MakeTime(18)))”}>} OrderID)

count( DISTINCT
{
<Customer_ID=P( {<Access_Week={$(=Access_Week)}>} Customer_ID)>*<Customer_ID=P( {<Access_Week={$(=Access_Week-1)} >} Customer_ID)>
}
Customer_ID)

 

c:

load if(Date_Closed=’null’,null(),Date_Closed) as Date_Closed, Record_ID inline [

Date_Closed ,    Record_ID

1/01/2015   ,       1

2/15/2015   ,       5

2/15/2015   ,       7

null        ,            10

null        ,            15

null        ,            15

];

and expression is

count({$ – <[Date_Closed]={‘*’}>} distinct [Record_ID])               result is 2

count({$ – <[Date_Closed]={‘*’}>} [Record_ID])                             result is 3

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.