Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST HERE
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.