topic Replace more than one dimension text in the graph in QlikView

Replace more than one dimension text in the graph

Tue, 08 May 2012 20:19:47 GMT

How do I create an expression that replaces more than one text in the dimension of graph?

FROM	TO
PP	PREMIER
AD	ADVANCE
PS	GOLD CLASS
PC	SUPER CLASS
PG	GLOBAL

I managed to make only one. How do more in the same expression?

Replace more than one dimension text in the graph

Tue, 08 May 2012 20:40:24 GMT

I would create a dummy table containing to columns, Segmento_mis with PP, AD, etc and the correct names in the other table. When loading the extra table Qlikview will automatically join the names and you can use the new column name as a dimension.

Replace more than one dimension text in the graph

Tue, 08 May 2012 20:42:55 GMT

how do I create this table in the SQL query?

Re: Replace more than one dimension text in the graph

Tue, 08 May 2012 21:01:59 GMT

You can use an If statement.

If(SEGMENTO_MIS = 'PP', 'Premier',
     If(SEGMENTO_MIS = 'AD', 'Advance',
          If(SEGMENTO_MIS = 'PS', 'Gold Class',
               If(SEGMENTO_MIS = 'PC', 'Super Class',
                    If(SEGMENTO_MIS = 'PG', 'Global')
               )
          )
     )
)

Hope this help you.

Regards.-

Re: Replace more than one dimension text in the graph

Tue, 08 May 2012 21:04:55 GMT

Can do it with If statement:

FROM	TO
PP	PREMIER
AD	ADVANCE
PS	GOLD CLASS
PC	SUPER CLASS
PG	GLOBAL

If(SEGMENTO_MIS = 'PP', 'Premier',
     If(SEGMENTO_MIS = 'AD', 'Advance',
          If(SEGMENTO_MIS = 'PS', 'Gold Class',
               If(SEGMENTO_MIS = 'PC', 'Super Class',
                    If(SEGMENTO_MIS = 'PG', 'Global')
               )
          )
     )
)

Hope this help you.

Regards.-

Replace more than one dimension text in the graph

Tue, 08 May 2012 21:14:18 GMT

Yeahhh

I did it and got:

LOAD * INLINE [

SEGMENTO_MIS, SEGMENT

PP, PREMIER

AD, ADVANCE

PS, GOLD CLASS

PC, SUPER CLASS

PG, GLOBAL

];

thanks regards

Re: Replace more than one dimension text in the graph

Tue, 08 May 2012 21:22:26 GMT

Great,

I did it and got:

LOAD * INLINE [

SEGMENTO_MIS, SEGMENT

PP, PREMIER

AD, ADVANCE

PS, GOLD CLASS

PC, SUPER CLASS

PG, GLOBAL

]

thanks regards

Replace more than one dimension text in the graph

Tue, 08 May 2012 21:23:16 GMT

Great,

I did it and got:

LOAD * INLINE [

SEGMENTO_MIS, SEGMENT

PP, PREMIER

AD, ADVANCE

PS, GOLD CLASS

PC, SUPER CLASS

PG, GLOBAL

]

thanks regards

Re: Replace more than one dimension text in the graph

Tue, 08 May 2012 21:25:20 GMT

Great,

I did it and got:

LOAD * INLINE [

SEGMENTO_MIS, SEGMENT

PP, PREMIER

AD, ADVANCE

PS, GOLD CLASS

PC, SUPER CLASS

PG, GLOBAL

]

thanks regards

Replace more than one dimension text in the graph

Tue, 08 May 2012 21:29:29 GMT

try...

pick(match(SEGMENTO_MIS, 'PP', 'AD', 'PS', 'PC', 'PG'),'PREMIER', 'ADVANCE', 'GOLD CLASS', 'SUPER CLASS', GLOBAL')

Replace more than one dimension text in the graph

Tue, 08 May 2012 21:30:15 GMT

try...

pick(match(SEGMENTO_MIS, 'PP', 'AD', 'PS', 'PC', 'PG'),'PREMIER', 'ADVANCE', 'GOLD CLASS', 'SUPER CLASS', GLOBAL')

Replace more than one dimension text in the graph

Tue, 08 May 2012 21:30:56 GMT

try....

pick(match(SEGMENTO_MIS, 'PP', 'AD', 'PS', 'PC', 'PG'),'PREMIER', 'ADVANCE', 'GOLD CLASS', 'SUPER CLASS', GLOBAL')

Replace more than one dimension text in the graph

Tue, 08 May 2012 21:33:16 GMT

try

pick(match(SEGMENTO_MIS, 'PP', 'AD', 'PS', 'PC', 'PG'),'PREMIER', 'ADVANCE', 'GOLD CLASS', 'SUPER CLASS', GLOBAL') in your table where you've used the Replace().

Replace more than one dimension text in the graph

CELAMBARASAN — Tue, 08 May 2012 21:35:45 GMT

Hi,

You can create dummy table

Load * inline[SEGMENTO_MIS,SEGMENTOMISFULLNAME

AD, Advance

PP, PREMIER

PS, GOLD CLASS

PC, SUPER CLASS

PG, GLOBAL];

use calculated dimension

=Pick(Match(SEGMENTO_MIS,'AD', 'PP', 'PS', 'PC', 'PG'),'ADVANCE','PREMIER','GOLD CLASS', 'SUPER CLASS', 'GLOBAL')

Celambarasan

Replace more than one dimension text in the graph

Wed, 09 May 2012 07:05:30 GMT

To start with, you can create an excel file with the two columns and load it in your script after the connect and sql statements.

Else you can create the table by using the INLINE function

Tab1:

Load * Inline [

Segmento_mis, Segmento_mis_Name

PP PREMIER

AD ADVANCE

PS GOLD CLASS

PC SUPER CLASS

PG GLOBAL

] (delimiter is '\t');

Replace more than one dimension text in the graph

Wed, 09 May 2012 07:20:42 GMT

Either create an excel table with the two columns and load it after the SQL statement, or create an inline table

Tab1:

Load * Inline [

Segmento_mis Segmento_mis_name

PP PREMIER

AD ADVANCE

PS GOLD CLASS

PC SUPER CLASS

PG GLOBAL

] (delimiter is '\t');

Replace more than one dimension text in the graph

teempi — Wed, 09 May 2012 07:34:07 GMT

Hey,

If those are the only possible values for SEGMENTO_MIS, you can use this load statement:

SegmentoMisNames:

LOAD * INLINE [

SEGMENTO_MIS, SEGMENTO_MIS_NEW

PP, PREMIER

AD, ADVANCE

PS, GOLD CLASS

PC, SUPER CLASS

PG, GLOBAL

];

You can then use the SEGMENTO_MIS_NEW field as the dimension for your graph.

-Teemu

Replace more than one dimension text in the graph

Wed, 09 May 2012 08:45:33 GMT

this may help.............

// SUPPOSE THIS IS YOUR TABLE

SEGMENTO_MIS:

LOAD

FROM,

from XYZ.QVD

// FOLLOWING WILL CREATE RUNTIME TABLE AND LINK WITH ABOVE TABLE ON FIELD "TO"

SEGMENTO_MIS1:

load * inline[

FROM,TO

PP,	PREMIER
AD	,ADVANCE
PS	,GOLD CLASS
PC	,SUPER CLASS
PG	,GLOBAL];

KINDLY CHK ATTATCHED FILE....

Replace more than one dimension text in the graph

Wed, 09 May 2012 13:49:03 GMT

Thanks very much for complete answer.