topic regarding lenth function in set analysis in QlikView

regarding lenth function in set analysis

qliksus — Fri, 18 Sep 2009 13:54:38 GMT

Hi,

I want to write a set analysis expression based on length of field . I have fields Year,Period,Number and Amount. Now Number contains Blank values also which is not a null value but lenght is 6. So i want the Total Amount without the blank value. So i have written the expression like,

sum({ <Year={$(#=max(@_Year))}>} Amount) -sum({ <Year={$(#=max(@_Year))},len(Number)={6}>} Amount)

But it is giving error in expression at len(Number) function.

Ans also i have 1-12 period for which i have to calculate current year and current period. Here no date field is there. How can i calulate the latest year and latest period??????

I am using max(Year) and it gives the correct answer but unfortunately max(Period) is giving the 12 number period of previous year. Can anyone help me????????

regarding lenth function in set analysis

qliksus — Fri, 18 Sep 2009 14:32:15 GMT

Also i want rename the Blank value as Others in Number field. Can anyone help me?????

regarding lenth function in set analysis

Anonymous — Fri, 18 Sep 2009 14:38:44 GMT

I don't think you can use anything other than field names on the left side of the = signs when defining your set analysis sets.

Len(Number) is in other words not allowed but you should be able to calculate this on the script side: Len(Number) as Len_Number and use this field in defining your set. I didn't look through the other stuff so I'm not sure if there was anything else to take into consideration.