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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
cristian_av
Creator III
Creator III

Select the "N Text" value from a dual field

Hi

I have a dual field in my master calendar called Cal_ID_MesAnoEP wich contains an integer and a text. The integer represents the number of payment, and the text shows a date and payment number.

I'm trying to use Point in Time Reporting with this value.

I have no trouble using the integer field, I can get the N period back values using the following statement:

=Sum(     {$<Cal_ID_MesAnoEP={"$(=Max(Cal_ID_MesAnoEP)-N)"},        Cal_AnoEP=,Cal_MesEP=>} CantidadServicios)

But I don't know how to get the the text field for N period back.

How can I do it?

1 Solution

Accepted Solutions
cristian_av
Creator III
Creator III
Author

For some reason I don't understand the text function returns the number but as text.

Finally I solved with MaxString:

MaxString(     {$<DualField={"$(=Max(DualField)-N)"},        Cal_AnoEP=,Cal_MesEP=>} DualField)

Thanks!

View solution in original post

2 Replies
Anonymous
Not applicable

text(Cal_ID_MesAnoEP) should return the text representation.

cristian_av
Creator III
Creator III
Author

For some reason I don't understand the text function returns the number but as text.

Finally I solved with MaxString:

MaxString(     {$<DualField={"$(=Max(DualField)-N)"},        Cal_AnoEP=,Cal_MesEP=>} DualField)

Thanks!