Visualization data

[kAOUTAR1]

Hello 

How i can transform data From table to textbox.

I want convert each line of my table to a textbox with all information.

Anyone have an idea .

Thanks 

[jbhappysocks]

Hi

It depends a little on what you have in your table. 

If you just have dimensions:

=concat([Dim1]&[Dim2]&[Val1]) creates a textstring with all your data

=concat(distinct [Dim1]&' '&[Dim2]&' '&[Val2],chr(10),4) creates something that looks more like your table, with space and line breaks

But if you have a measure in your table, I think you must make the calculation in the script.

If we use Sum(Val1) instead of just Val1, and add a line, you would get this:

Add something like

join (Data) load Dim1,Dim2, sum(Val1) as Val2 Resident Data Group By Dim1, Dim2;

to your script and use 

=concat(distinct [Dim1]&' '&[Dim2]&' '&[Val2],chr(10),4)

in your text box to get

[kAOUTAR1]

Thanks for your answer

I have only dimensions, can you tell me where i have to type this script. I'm beginner and I just start to use qlicksence. 

[jbhappysocks]

Absolutely

Drag a Text & Image onto you sheet. Don't press the + in the box, instead you want to add a measure, there you enter the script.

(My Qlik is in Swedish, but you can see here where to do it)

=concat(distinct [Dim1]&' '&[Dim2]&' '&[Val1],chr(10))

chr(10) creates the line break

The 4 in the end in my original script was not supposed to be there, don't know how it ended up there, so don't try to understand it 🙂