topic How do I separate 001 and 01 values? in QlikView

How do I separate 001 and 01 values?

Mon, 06 Feb 2012 06:26:34 GMT

Hi guys!

I have a table which has key values in first row.

Those values can be 01, 00001 and 001. Qlikview doesn't make difference between those values, but has to. How do I force it to make the difference?

THANKS A LOT!

kaushiknsolanki — Mon, 06 Feb 2012 06:30:48 GMT

Hi,

When you load that column define them as a text column.

like shown below.

Load

text(XYX) as XYX

From abc;

Here XYX is a field which contains the 001, 0001 and so on values.

Hope you understood.

Regards,

Kaushik Solanki

Mon, 06 Feb 2012 06:56:17 GMT

Thanks a lot!!

kaushiknsolanki — Mon, 06 Feb 2012 06:58:15 GMT

Hi,

My pleasure.

Regards,

Kaushik Solanki

Fri, 10 Feb 2012 08:41:13 GMT

Hi all,

I'm trying to do in that way, but in my enviroment it do not work. How can I solv it?

Regards,

Dzintars