Function of Character

pgalvezt — Wed, 13 Aug 2014 17:00:37 GMT

Hi,

I have a pivot table where I have fields loaded from other app and just call thats fields in my second app. But in the others columns I have formulas that brings last month. The formulas are right, But I have one field that shows Character So.

Column A (only the field) Column B

Character1 -

Character2 -

So on

In coIumn B I have to bring Character1 Character2 (Comparison columns) but with the last month and same day, Example if in Column A Brings 13-08-2014 in column B Should brings 13-07-2014.

My formula is

=Sum({<fecha={'>=$(=Date(Max(fecha) - 31))<=$(=Date(Max(fecha) - 31))'}>} Inv)/2

Where Inv is numeric This bring me Same day last month

=Sum({<fecha={'>=$(=Date(Max(fecha) - 31))<=$(=Date(Max(fecha) - 31))'}>} Per)/2

Where Per is a character so, Column B brings null values.

How can I show character in set analisys?

Thanks!

Re: Function of Character

Wed, 13 Aug 2014 17:40:13 GMT

You can try ONLY or Maxstring functions, as Set analysis can be used only with aggregation functions.

topic Function of Character in QlikView

Function of Character

Re: Function of Character