topic How to change the Data at Qlikview level? in QlikView

How to change the Data at Qlikview level?

hkg_qlik — Mon, 10 Jan 2011 06:48:13 GMT

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,

deepakk — Mon, 10 Jan 2011 06:51:18 GMT

HI,

Load

('Quater ' & Qtr ) as Quarter

from Test;

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

jonathandienst — Mon, 10 Jan 2011 06:53:47 GMT

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

Mon, 10 Jan 2011 06:55:07 GMT

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

Mon, 10 Jan 2011 07:53:09 GMT

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.