topic Re: Data transformation in QlikView

Data transformation

Funsho — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Data transformation

dplr-rn — Thu, 19 Mar 2020 14:02:11 GMT

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

Re: Data transformation

fabb95501 — Thu, 19 Mar 2020 14:12:39 GMT

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