Separating data from one column into multiple columns

Tue, 12 Jan 2010 10:58:50 GMT

Hi, I am creating a system to look at the response times for our support systems, I have managed to calculate a variable for Days since called logged, now what I want to be able to do is split this data up into 6 different types, 1 day old, 2 days old, 3 days old, 4 days old, 5 days old and 6 days plus. What is the best way to do it?

At the moment I am considering using:

Load * From where Days since logged = '1'

STORE INTO TEMP/1.qvd;

Then repeating the same for 2,3,4,5 and 6+

Then I was intending loading them all and concatening them together. However I was speaking to someone the other day who said there was a far easier way to do this sort of load rather than creating a new temporary qvd for each of the fields I am interested in. Can anyone help explain what this is and possibly provide an example qvd? Sorry this is a bit vague.

Cheers

Ben

Separating data from one column into multiple columns

Tue, 12 Jan 2010 11:16:41 GMT

Hi Ben,

see this example using INTERVALMATCH.

Good luck!

Rainer

Separating data from one column into multiple columns

Tue, 12 Jan 2010 11:17:56 GMT

or this one using CLASS()

Rainer

topic Separating data from one column into multiple columns in QlikView

Separating data from one column into multiple columns

Separating data from one column into multiple columns

Separating data from one column into multiple columns