Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
HI,
Load
('Quater ' & Qtr ) as Quarter
from Test;
Where Qtr is the field name and I am concatenating string 'QUarter' to it.
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
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
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.