Join two fields in one in Straight Table

lazarides — Wed, 29 Aug 2018 07:11:41 GMT

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!

Re: Join two fields in one in Straight Table

MarcoWedel — Wed, 29 Aug 2018 21:44:19 GMT

please post some sample data and your expected result.

thanks

regards

Marco

Re: Join two fields in one in Straight Table

lazarides — Thu, 30 Aug 2018 06:20:52 GMT

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.

topic Re: Join two fields in one in Straight Table in QlikView

Join two fields in one in Straight Table

Re: Join two fields in one in Straight Table

Re: Join two fields in one in Straight Table