topic Re: Quick Set Analysis help.... in QlikView

Quick Set Analysis help....

Thu, 04 Dec 2014 18:11:55 GMT

...Hi all,

Can someone help me by putting the following into some set analysis please?

I've been strugglnig with this all day and I'm officially stuck;

I would like to sum the field FUMValue where the RetMonthName and AUMMonthName are the same, these are how I've calculated the two month fields;

RetMonthName = MonthName(AddMonths([retired date]),-2))

AUMMonthName = MonthName(MonthYear)

I'm struggling with adapting the above to work within set analysis as I don't want to actually create the fields separately, can someone please help?

Kind Regards,

mato32188 — Thu, 04 Dec 2014 18:25:43 GMT

Hi Samuel,

create a flag in script: if(RetMonthName = AUMMonthName, 1, 0) as @MonthEq

then

sum({<@MonthEq = {'1'}>}FUMValue)

JonnyPoole — Fri, 05 Dec 2014 02:00:39 GMT

You can do it but you need a field context... for which field values are you making this comparison ?

If it was for a ProductID for example use the SEARCH syntax (double quotes) with a preceding '=' sign before the condition.

count( {$<ProductID={"=(MonthName(AddMonths([retired date]),-2)))=MonthName(MonthYear)"}>} ProductID)