Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Function of Character

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!

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

1 Reply
Not applicable

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

View solution in original post