How to change the Data at Qlikview level?

[hkg_qlik]

Hi,

I am using Time Dimension Table from a Data Warehouse. But in the Time Dimension Table the Quarter field is loaded as 1, 2, 3, & 4.

Now at the reporting end in QlikView I want the 1 to look like Q1 or Quarter - 1 or something like that.

Is it possible to change it? if yes ...HOw?

Thanks,

H

[deepakk]

HI,

Load

('Quater ' & Qtr ) as Quarter

from Test;

Where Qtr is the field name and I am concatenating string 'QUarter' to it.

[jonathandienst]

H

Several ways of doing this.

For example - in the load statement:

LOAD ....
'Quarter - ' & Quarter AS Quarter,
....
FROM ....

You could also do this in the SQL SELECT statement (assuming this is coming from a database), or via a mapping table.

Jonathan

[#4]

while loading the dime in the load script, have something similar to this;

Load AA,

BB,

...

if(Quarter='1', 'Q1' , if (Quarter='2','Q2', if(Quarter='3','Q3', if(Quarter='4','Q4) ))) as Quarter,

....

from....;

Rgds,

K G

[#5]

You can also use ApplyMap function to translate the numeric values of quarter as Q1 or Quarter 1.

Before using apply map you would need to have a mapping table.