Solved: Re: Qlikview converting Text to Number and removin... - Page 2 - Qlik Community

Report Inappropriate Content · ‎2013-10-15

Hi All,

For following example:

Load * Inline [Account_Type

'20.001',

'20.00100',

'20.0010'];

How to insure qlikview shows up three values in List box or aggregated pivot.

What we are seeing is

result of above example is :

20.001

Therefore in list box it will display 1 row. If we try to aggregate any data, rather than 3 different account types, it aggregates to 1 row.

Please advise.

Regards

Ravi

MayilVahanan · ‎2013-10-16

Hi

Try like this

LOAD

...

Text(Account_type) as Account_type;

SQL SELECT

Account_type,

...

FROM DBTABLE;

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Report Inappropriate Content · ‎2013-10-16

Thanks everyone.

Have to say this was not straight forward and not straight way to handle it. Most of standard tools do keep in mind data type while selecting.

Thanks

Regards

Ravi

swuehl · ‎2013-10-16

Agreed that this might not be intuitive.

Please check these blog posts:

Qlikview converting Text to Number and removing leading zeros