topic Re: Regarding comparing 2 field values in QlikView

Regarding comparing 2 field values

SK111 — Fri, 24 Feb 2023 21:35:12 GMT

Hi,

I appreciate your time. I am trying to compare 2 field values and show the 3rd field called amount if they are same. I tried below but getting duplicate row.

=if(sales_vendor = volume_vendor,amount,'-')

I tried the above in an Qlik Sense table expression, but I am getting duplicate row. First row with amount and the second row with a '-'

some thing like below

sales_vendor,product,sales,amount

1,A,10$,5

1,A,10$,-

I have unchecked to include null values option.

Thank you!

Re: Regarding comparing 2 field values

sidhiq91 — Sat, 25 Feb 2023 06:09:29 GMT

@SK111 Could you please follow the below code:

NoConcatenate
Temp:
Load Sales_Vendor,
Product_Vendor,
if(Sales_Vendor=Product_Vendor,Amount,null()) as Amount

inline [
Sales_Vendor, Product_Vendor, Amount
10,10,5
11,11,6
12,14,7
13,12,8
];

Exit Script;

In your expression '-' is not considered as null, hence the issue.

If my solution resolves your issue, please like and accept it as a solution.

Re: Regarding comparing 2 field values

SK111 — Mon, 27 Feb 2023 14:41:31 GMT

Hello,

Appreciate your time. I am trying to apply this in the chart expression,since the sales_vendor is an example but its the vendor who logins into the report.

=if(login_vendor =[Vendor],Amount,null())

But if condition takes lot of time to reload the chart. Is there any other alternative to remove this if condition.

Thank you!