topic Re: How to write if condition in QlikView

How to write if condition

abc_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

how to fulfil two condition in same expression.

This is the table attached below.

Expression which I am using for Amount LCY with split column is:-

=if(ProformaParent<>'NULL' and Split1=split ,sum(split*total_amount_fct)/100 ,

if(ProformaParent<>'NULL' and Split1<>split ,sum(split*total_amount_fct)/100 )

Requirement is if split1=split then this formula sum(split*total_amount_fct)/100 should apply, otherwise if split1<>split

then sum(split*total_amount_fct)/100 formula should be applicable.

I tried to do that, but at a time only one condition is fulfilling.

Kushal_Chawda — Mon, 09 May 2016 07:03:41 GMT

For both the condition expressions is same (sum(split*total_amount_fct)/100)? try below

if(ProformaParent<>'NULL' and (Split1=split or Split1<>split), sum(split*total_amount_fct)/100)

Anonymous — Mon, 09 May 2016 07:04:58 GMT

SUM(IF(Not(IsNull(ProformaParent)),IF(split1<>split,sum(split1*total_amount_fct)/100,sum(split*total_amount_fct)/100))

Regards

santhosh_k_n — Mon, 09 May 2016 07:07:20 GMT

Hi Shikha,

Please try below,

if(ProformaParent<>NULL() and Split1=split ,sum(split*total_amount_fct)/100 ,

if(ProformaParent<>NULL() and Split1<>split ,sum(split*total_amount_fct)/100 ))

Regards,

Anonymous — Mon, 09 May 2016 07:24:30 GMT

Sorry, my last expression is wrong:

SUM(IF(Not(IsNull(ProformaParent)),IF(split1<>split,split1*total_amount_fct/100,split*total_amount_fct/100)))

We put IF conditions into sum expression to calculate the correct result on total rows.

Regards

ankit777 — Mon, 09 May 2016 08:03:17 GMT

try this

if(not isnull(ProformaParent) and Split1=split ,sum(split*total_amount_fct)/100 ,

if(not isnull(ProformaParent) and Split1<>split ,sum(split*total_amount_fct)/100 ))

pooja_sn — Mon, 09 May 2016 08:05:40 GMT

Why do you need Split1 comparison condition, if you expect to display same expression in both the cases ?

Peter_Cammaert — Mon, 09 May 2016 08:25:15 GMT

Indeed. The solution to your current post doesn't need two conditions. It can be resolved using this expression:

=IF (NOT IsNull(ProformaParent), Sum(split * total_amount_fct) / 100)

Can you rewrite your OP to make it more clear what you're after? Thanks.

Peter