Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Formula guidebook or help

Hi all,

I am a bit new to Qlikview, however I try to make nice reports. Does anybody have a link where I can find explanations about the formulas?

Such as this one?

count(distinct{$<[Fiscal Year] = {2011}, [Partner Geo] = {'AMER'}, [Program Name] = {'ACE'}, [First-in]= {1}, DateFlag = {'Submitted'}>}if((agg(sum([Sold Value SRP]),[Opportunity ID])>50000),[Opportunity ID])

I am trying to understand these, but I am not succeeding, therefor my own formulas don't work.

Right now I am trying to get the number of unique customers [ID_RELATIE], that have as [KLANTGROEP] the value 'Strategic Account'

Should be an easy formula, but I don't get the proper number.

Thanks!!

1 Solution

Accepted Solutions
martinpohl
Valued Contributor II

Formula guidebook or help

Hello Wouter,

you need to move the distinct behind }>} and delete the comma.

count ({$<KLANTGROEP={'STRATEGIC ACCOUNT !!'}>}distinct RELATIE_ID)

Regards

5 Replies
marcel_olmo
Contributor III

Formula guidebook or help

Hey wouter,

could you be more specific about what you don't understand exactly about the formulas?

Qlikview has a useful and complete "help" tab, that should be enough to understand that.

Specially with the "set analysis" stuff.

Hope it helps!

Not applicable

Formula guidebook or help

Well, I don't understand the syntax.

Is this a correct formula (Probably not, since it doesn't give me the output):

=

count (distinct {$<KLANTGROEP={'STRATEGIC ACCOUNT !!'}>} ,RELATIE_ID)



googel84
Contributor III

Formula guidebook or help

I must say I'm not very sure because I've never tried before a set analysis similar to the one you are trying to interpret.

From my point of view you are counting distinct values of Opportunity ID that respect the following conditions:

  • Fiscal Year = 2011
  • Partner Geo = AMER
  • Program Name = ACE
  • First-in = 1
  • DateFlag = Submetted
  • the amount of Sold Value SRP greater than 50000

To find out more information on set analysis, please see page 1252 of QlikView Reference Manual. You might see also details on aggr function at page 1251.

Hope it helps.

martinpohl
Valued Contributor II

Formula guidebook or help

Hello Wouter,

you need to move the distinct behind }>} and delete the comma.

count ({$<KLANTGROEP={'STRATEGIC ACCOUNT !!'}>}distinct RELATIE_ID)

Regards

Not applicable

Formula guidebook or help

thank you all for the help, it worked!!!

Wouter

Community Browser