Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

How to change the Data at Qlikview level?

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

4 Replies
Highlighted
Partner
Partner

How to change the Data at Qlikview level?

HI,

Load

('Quater ' & Qtr ) as Quarter

from Test;

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

Highlighted
MVP
MVP

How to change the Data at Qlikview level?

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

How to change the Data at Qlikview level?

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

Highlighted
Not applicable

How to change the Data at Qlikview level?

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.