Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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