Transforming data fields within Qlik Sense

[JavierBlanco]

Hi everybody,

My client wants to visualize data in a way, given the data source they're also providing, I think it's pretty complicated to; let me explain the issue with an example:

I'm receiving data in CSV files, tables like this:

store_id, target_serv1, target_serv2, ..., target_servN, achieve_serv1,  achieve_serv2, ..., achieve_servN

But they want me to represent it this way:

                      Target   Achievement        

Service 1   

Service 2

...

Service n

I think it's not possible to do this without transforming the data within Qlik, I guess using its script language. It's my first project with Qlik and, besides that, I'm used to work with another BI software but always with MySQL sources, so I decide how to import data using SQL, so I would need some starting hints: do I need to alter the loading script, creating new fields, or maybe in a later stage, via variables... ?

Any help would be greatly appreciated, thanks in advance. 

[JavierBlanco]

Hi, Marcus,

Does this kind of syntax have an specific name? Or where could I find more information about it?

Thanks a lot!

[marcus_sommer]

Yes, it's a special feature called set analysis. See more here: A-Primer-on-Set-Analysis .

- Marcus