topic Re: Help: How to separate one column into two?? in QlikView

Help: How to separate one column into two??

Thu, 06 Dec 2012 18:40:20 GMT

Hello All,

I have a column in my data, named Count: basically it counts the # of pcs or skids.. so this is what it would look like

Count
1 skid
4 skid

6pcs

2 pcs

4skid

so my question is, how do i separate them into two different columns named skid count and pcs count??

Re: Help: How to separate one column into two??

MayilVahanan — Thu, 06 Dec 2012 19:13:11 GMT

Try like this

Load *,if(WildMatch(Count,'*skid'),'Skid Count','Pcs Count') as TestField Inline

[

Count

1 skid

4 skid

6pcs

2 pcs

4skid

];

Load * Inline

[

CountTest

1 skid

4 skid

6pcs

2 pcs

4skid

] where WildMatch(CountTest,'*skid');

Re: Help: How to separate one column into two??

vgutkovsky — Thu, 06 Dec 2012 20:38:24 GMT

How about this:

if(substringcount(Count,'pcs')>0,Count) as PCSCount,

if(substringcount(Count,'skid')>0,Count) as SKIDCount

Regards,

Vlad

Re: Help: How to separate one column into two??

Thu, 06 Dec 2012 21:25:15 GMT

Hi,

check out little example. I coded three versions, whatever fits best. comment or uncomment one of them.

I assumed that you want to seperate the column during the load. This is at leat better than in charts or so.

HtH

Roland

Re: Help: How to separate one column into two??

Fri, 07 Dec 2012 14:53:38 GMT

Mr. Roland,

You are absolutely Amazing!!!! Thank you so much for your help!!!

Re: Help: How to separate one column into two??

Fri, 07 Dec 2012 16:28:48 GMT

Thank you so much Vlad

Re: Help: How to separate one column into two??

Fri, 07 Dec 2012 16:28:54 GMT

Thank you so much!

Re: Help: How to separate one column into two??

Fri, 07 Dec 2012 19:21:33 GMT

Hi again,

glad to help you

Re: Help: How to separate one column into two??

Fri, 07 Dec 2012 19:43:04 GMT

Mr. Roland,

I realized there's a small flaw in your code,

if you look at the count, there are 2 4 skid, but if u look at the #skid1 table, there's only 1 4 shown.

can you tell me how to solve this??

Re: Help: How to separate one column into two??

Fri, 07 Dec 2012 22:51:57 GMT

Hi Jim,

don't worry, this is correct.

QV "optimizes" several identical values of a field to one entry in a listbox. To proof this please check properties --> general tab --> show frequency.

Same feature can be found in tableboxes, if 2 or more complete rows are identical.

Roland

Re: Help: How to separate one column into two??

Tue, 05 Feb 2013 16:56:48 GMT

Thank you so much Mr. Roland.