Solved: How do I separate 001 and 01 values? - Qlik Community

Report Inappropriate Content · ‎2012-02-06

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 · ‎2012-02-06

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

kaushiknsolanki · ‎2012-02-06

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2012-02-06

Thanks a lot!!

kaushiknsolanki · ‎2012-02-06

Hi,

My pleasure.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2012-02-10

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