topic Re: Calculated expression in the script in QlikView

Calculated expression in the script

apoorvasd — Sat, 03 Sep 2016 13:23:29 GMT

Hi All,

I have three fields say, A, B and C (where C is an account number). All these three fields contain numeric values(all of these have same number of digits). Now I need to calculate the "Amount" using these three fields which should satisfy the following conditions:

1. Calculate the amount when first 4 digits of A and B are not equal, for so and so account numbers

2. Calculate the amount for rest of the account numbers, independent of the condition that is specified in 1 (i.e. "first 4 digits of A and B not equal" should not be applied).

How do I write an expression or a where clause which satisfies both the conditions mentioned above for calculating the "Amount"?

Any suggestions on this?

Thank you.

Re: Calculated expression in the script

sunny_talwar — Sat, 03 Sep 2016 17:30:42 GMT

Would you be able to provide 4-5 lines of input data with the expectation of the output?

Re: Calculated expression in the script

Anil_Babu_Samineni — Sat, 03 Sep 2016 17:31:23 GMT

1) Perhaps This

Aggr(If([Account number] <> left([Account number],4)),Sum(amount))

i didn't understand your 2nd Question.

Re: Calculated expression in the script

apoorvasd — Mon, 05 Sep 2016 15:08:06 GMT

Hello,

Thanks for the suggestion.

1st condition should be applied only for specific account numbers and the 2nd condition should be applied for rest of the account numbers (i.e. it shouldn't consider the values of fields A and B). Let me know if this is clear.

Re: Calculated expression in the script

apoorvasd — Mon, 05 Sep 2016 15:52:26 GMT

Hello,

Sorry i can just tell that fields, A, B and C (Account Number) all have 10 digit numeric values.

Like, A = 0005003000, 0005003999 etc

B = 0005008899, 0005002291 etc

Account Number = 0004300910, 0004300920 etc