if else

[#1]

Hi All,

I have 2 tables

Table A

Customer no ¦   Product Numbers

10                             222222

11                             33234234

12                             4232434

Table B

Customer no ¦   Name   ! Addresss

12                            A

13                            B

14                             C

I have joined these 2 tables. based on Customer number.

Here in Table B we do not have data for customer number 10 and 11. so for this I need to show as if customer number is 10 then 'not present'  and customer number is 11 then 'Old Customer'

I tried in expression few things.. didn't work..

[PrashantSangle]

Hi,

On what basis you are considering

Customer No 10 as 'Not Present' and

Customer No 11 as 'Old Customer'

Regards

[#3]

Hi Max.

As few products are assigned to them via table A in the database. I would like to present them as such.

[PrashantSangle]

Hi,

Can you post your expected output w.r.t above inputs. So that it will be easy to suggest code.

Regards,

[sasiparupudi1]

It is not clear from your explanation what text your want for customer

10   and customer  11... I am assuming that they both must show old customer as they both have a product number.

The customers who do not have any product number associated should be marked as 'Not Present'. Am I right?

Please explain

Sasi

[#6]

No

If you see Table A .. Shows Customer number and the product number

Table B Shows the Customer data in detail like name , address etc.

in the database they are independent tables. But in qlikview Iam joining these tables .iam getting the output as such

Output table

---------------------

Customer no             ¦    Name                     ¦ Address       ¦  Product Number

10                                     -                                       -                 222222

11                                     -                                       -                33234234

12                                    A                                      xx                  4232434

Iam looking output as below.

Output table

---------------------

Customer no             ¦    Name                     ¦ Address       ¦  Product Number

10                                Not Present                                       -      222222

11                                 Old Customer                        -                33234234

12                                    A                                      xx                  4232434

[#7]

is still there a  confusion?

[sasiparupudi1]

Yes

what makes

10   as

Not Present

and

11 as Old Customer

[settu_periasamy]

Hi,

how to identify the Old Customer and Not present? do you have any criteria or is that static?

if so,  try this..

TableA:

LOAD * INLINE [

    CustNo, Product

    10, 222222

    11, 33234234

    12, 4232434

];

Join

LOAD * INLINE [

    CustNo, Address

    12, A

    13, B

    14, C

];

NoConcatenate

Final:

Load CustNo,

  if(CustNo=10,'not present',

  if(CustNo=11,'Old Customer',Address)) as Address,Product Resident TableA;

  DROP Table TableA;

[#10]

Hi sasidhar,

Not present and Old customer is just an example name. I could keep any other..

As in the detailed customer table we do not have data for this. I want to specifically fill it with hard code names when displaying in the report.