Discussion Board for collaboration related to QlikView App Development.
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?
('Quater ' & Qtr ) as Quarter
Where Qtr is the field name and I am concatenating string 'QUarter' to it.
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.
while loading the dime in the load script, have something similar to this;
if(Quarter='1', 'Q1' , if (Quarter='2','Q2', if(Quarter='3','Q3', if(Quarter='4','Q4) ))) as Quarter,
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.