topic Re: if command with InputSum in QlikView

if command with InputSum

thanhphongle — Thu, 19 May 2016 12:19:24 GMT

Hello community,

this is my database:

Category	Rent term	Factor
Car	12	6%
Car	24	5%
Ship	12	8%
Ship	24	4%
Estate	36	2%
Estate	48	1%

I want to create a table where I can manually put the rent term by the function InputSum. See below

Category	InputSum([Rent term])	Factor
Car	24	5%
Ship	12	8%
Estate	36	2%

When I add for example 24 in the InputSum column, QV should check if InputSum([Rent term]) = 24, search 24 in [Rent Term] and give out the referring Factor which is 5%.

Can anyone help me how to create an expression which can do this?

Re: if command with InputSum

Thu, 19 May 2016 12:23:40 GMT

Can you explain little bit more. I can't understand what you are looking for.

Re: if command with InputSum

thanhphongle — Thu, 19 May 2016 12:44:54 GMT

I want to create a list where i can manually put a number in a list for the [Rent term] by the function InputSum. After putting in a number in the column where the InputSum function is, qv should compare the number with the existing number in the database and assign the proper factor.

for example:

in a table chart i have

Category=Car, Ship & Real Estate, now i create a function called InputSum([Rent term]), now i add the numbers in the function.

Category InputSum([Rent term]) [Rent term] Factor

Car 24 12 or 24 6% or 5%

Ship 12 12 or 24 8% or 4 %

Real Estate 36 36 or 48 2% or 1%

Then QV should compare the adding number with the existing numbers in the database

Car = 24 search for 24 in [Rent term], if you find it , return the factor 5%

Ship= 12 search for 12 in [Rent term], if you find it , return the factor 4%

Real Estate= 36 search for 36 in [Rent term], if you find it, return the factor 2%

Hope you understand what my problem is

Re: if command with InputSum

thanhphongle — Thu, 19 May 2016 13:10:21 GMT

And somehow my INPUTFIELD command in the script is not working... My script

INPUTFIELD [Rent term];

LOAD

Category,

[Rent term],

Factor

FROM

[A-Import_ITFM.xlsx]

(ooxml, embedded labels, table is Grunddaten);

Error message:

Duplicate keys when loading Input Field

Re: if command with InputSum

thanhphongle — Fri, 20 May 2016 10:10:36 GMT

Is there nobody who can help me?