Data transformation

[Funsho]

Good day all. Please i loaded an excel file that contains some grouped numbers, but i do not want it grouped after loading the file in Qlik view. Thank youPlease i want them to all appear on the same line

[dplr-rn · Accepted solution]

hi

its not a grouping. what you are seeing is qlik getting confused a little on data types.

the ones like 132.05 qlik is identifying as number. others as text

you should make everything as string like so Text(CODES) as CODES

[fabb95501 · Accepted solution]

Hi,

go to List Box Properties > Presentation > Alignment and set the same alignment for Text and Numbers.

In your situation, 132.05 is recognized by Qlikview as a number, 132.05.01 as a text.

Regards,

Fabio