topic Re: if else in QlikView

if else

Wed, 16 Sep 2015 10:07:49 GMT

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..

Re: if else

PrashantSangle — Wed, 16 Sep 2015 10:19:28 GMT

Hi,

On what basis you are considering

Customer No 10 as 'Not Present' and

Customer No 11 as 'Old Customer'

Regards

Re: if else

Wed, 16 Sep 2015 10:43:16 GMT

Hi Max.

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

Re: if else

PrashantSangle — Wed, 16 Sep 2015 10:49:34 GMT

Hi,

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

Regards,

Re: if else

sasiparupudi1 — Wed, 16 Sep 2015 10:51:45 GMT

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

Re: if else

Wed, 16 Sep 2015 11:03:48 GMT

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

Re: if else

Wed, 16 Sep 2015 12:09:11 GMT

is still there a confusion?

Re: if else

sasiparupudi1 — Wed, 16 Sep 2015 12:12:50 GMT

Yes

what makes

10 as

Not Present

and

11 as Old Customer

Re: if else

settu_periasamy — Wed, 16 Sep 2015 12:30:02 GMT

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;

Re: if else

Wed, 16 Sep 2015 12:32:41 GMT

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.

Re: if else

Wed, 16 Sep 2015 12:33:21 GMT

yes settu ..it is static ..just some hard coded value. can I do this somewhere in expression also?

Re: if else

settu_periasamy — Wed, 16 Sep 2015 12:40:05 GMT

i think you can do the same in expression also. if you have the dimension as Customer Number, you can put the expression like below..

if(CustNo=10,'not present',

if(CustNo=11,'Old Customer',Address))