topic Re: Set analysis error in QlikView

Set analysis error

Tue, 28 Aug 2012 10:02:53 GMT

I am trying to do some set analysis to just show results for the current year. The field I want to use for the year contains the date in the format DDMMYYYY so I am using the year() function but it appears to be giving me an error.

Does anyone know what I'm doing wrong in the expression below?

Sum({$<year(CampaignMemberCreatedDate)={2012}>} Amount__c)

Thanks

Jon

Re: Set analysis error

Tue, 28 Aug 2012 10:09:37 GMT

check this:

Sum({$<CampaignMemberCreatedDate={'*2012'}>} Amount__c)

Re: Set analysis error

rajni_batra — Tue, 28 Aug 2012 10:11:13 GMT

try

Sum({< $(year(CampaignMemberCreatedDate))={2012}>} Amount__c)

or create a variable for year(Date)= vyear

Sum{<$(vyear)={2012}>}Amount_c)

Re: Set analysis error

Anonymous — Tue, 28 Aug 2012 10:17:42 GMT

The error is that you're trying to use expression here

Sum({$<year(CampaignMemberCreatedDate)={2012}>} Amount__c)

But only field name can be used on the left side of the equasion. That's why the suggestion from Pari Pari is technically correct.

Regards,

Michael

Re: Set analysis error

Tue, 28 Aug 2012 10:22:22 GMT

You don't usethe function into set analysis, else function aggragation example min,max,avg ecc.

So you have 3 possibile solution:

1)Sum({$<CampaignMemberCreatedDate={'*2012'}>} Amount__c)

2)you create a variable set pippo= '*' &YEAR(today())

Sum({$<CampaignMemberCreatedDate=$(#pippo)>} Amount__c)

Sum({$<CampaignMemberCreatedDate="$(#pippo)">} Amount__c)

(i dont' remeber if you to use "")

4)into a script you create YEAR(CampaignMemberCreatedDate) as ANNO

4a)Then

set pippo2= YEAR(today())

Sum({$<ANNO=$(#pippo2)>} Amount__c) or Sum({$<ANNO="$(#pippo2)">} Amount__c)

4b)

Sum({$<ANNO={'2012'}>} Amount__c)

bye Marchetto

Re: Set analysis error

Tue, 28 Aug 2012 10:41:27 GMT

Thanks, all!