Skip to main content
Announcements
See why Qlik was named a Leader in the 2025 Gartner® Magic Quadrant™ for Augmented Data Quality Solutions: GET THE REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
lazarides
Contributor

Join two fields in one in Straight Table

Good Morning,

I have a table in which the name of one of the fields has been modified, since a historical table has the two fields, access_radio_on_air and access_radio_on_air_cobertura (these correspond to the field technical_name of the tasks table). Each of these fields has related three types of date, Planned, Forcast and Real and an SSP (provider). What I would need is that when generating the table in that specific case, concatenate the two fields in access_radio_on_air_coverage, but the other technical_name remain the same.

 

I've tried putting a type condition

=if((tasks.technical_name = "acceso_radio_on_air" or tasks.technical_name = "acceso_radio_on_air_cobertura"), "pepe", tasks.technical_name)

in the section of Dimensions / Settings for selected Dimension (with enable conditional) in the dimensiont technical_name and something similar in Expressions but for each of the dates and I can not do it.

Attached captures

Chart Properties/Dimensions/Used Dimenssions

Chart Properties/Expressions

I hope you can help me.

Thank you very much!

2 Replies
MarcoWedel

please post some sample data and your expected result.

thanks

regards

Marco

lazarides
Contributor
Author

I attach print scrints in the post but this is what i need:

In the top the 2 technical_name and below what i need, the union of the fields in one.