Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lukasrocek21
New Contributor III

Replace the record with others

Hi all,

I have a problem with this code:

[GoalTab]:

LOAD

   

    if(BU='A' or BU='B', BU = 'AB', BU) as BU,

    Goal

FROM [...path.xlsm]

(ooxml, embedded labels, table is GOAL);

I want to replace A or B by AB, but in vizualization is 0 (each other record is OK within AB...).

Thanks for your answers...

1 Solution

Accepted Solutions
prat1507
Valued Contributor

Re: Replace the record with others

Use

[GoalTab]:

LOAD

  

    if(BU='A' or BU='B', 'AB', BU) as BU,

    Goal

FROM [...path.xlsm]

(ooxml, embedded labels, table is GOAL);

2 Replies
prat1507
Valued Contributor

Re: Replace the record with others

Use

[GoalTab]:

LOAD

  

    if(BU='A' or BU='B', 'AB', BU) as BU,

    Goal

FROM [...path.xlsm]

(ooxml, embedded labels, table is GOAL);

lukasrocek21
New Contributor III

Re: Replace the record with others

Thank you very much

Community Browser