Formula guidebook or help

[#1]

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!!

[marcel_olmo]

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!

[#3]

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]

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 · Accepted solution]

Hello Wouter,

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

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

Regards

[#6]

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

Wouter