Qlik Usefull Functions

[Billy_u]

hi everyone,

I'm try to use the table functions to say turn the table itself automatically, but i have a problem with this function  that doesn't work,

thank you

hi

[JordyWegman]

Hi Billy,

Please check the crosstable load in this link.

Jordy

Climber

[Billy_u]

it is not very understandable, 

thank you for the request

[JordyWegman]

What is it that you want to create? Can you maybe show an image?

Jordy

Climber

[Billy_u]

hi, i trust to clearly to explain

transform the table above in non manual way in the table below

the idea is here:

[JordyWegman]

Hi Billy,

I don't know the exact statement, but you can also do this with the Data Manager: https://www.youtube.com/watch?v=D_03gU8GvK8

When you did this, go back to the script (check the 'locked' part) and get the script for unpivoting.

Jordy

Climber

[Vegar · Accepted solution]

Try

CROSSTABLE (Indicatore, MyPos3)
LOAD 
  'Placeholder' as Placeholder, 
   Periodo, 
   Passaggi,
   Passeggeri, 
   Destinazioni
FROM 
   LIB://ok/Transporti.csv (...);

DROP FIELD Placeholder;

[Billy_u]

thank you, this is good and clean, but i have another question:

is it possible to match the period? Adding a column for each record?

[Vegar · Accepted solution]

If the year is important across the other dimensions then you could skip the placeholder.

CROSSTABLE (Indicatore, MyPos3)
LOAD
Periodo,
Passaggi,
Passeggeri,
Destinazioni
FROM
LIB://ok/Transporti.csv (...);

By this approach you could select period and get associated values.