topic Input Box and Calculations in QlikView

Input Box and Calculations

alec1982 — Wed, 13 Nov 2013 19:46:48 GMT

Hi Guys,

On one of the tables that I have on the script I got the following calculation:

Load

ID,

Resident XYZ;

On the other hand I have an input box on the tab where the user can enter a value and store in variable VV.

Is there anyway to add a new column in the script to have the following

Load

ID,

LL * Variable(VV) as MM

Resident XYZ.

Thxs,

Alec

Re: Input Box and Calculations

Anonymous — Wed, 13 Nov 2013 19:53:27 GMT

It will be:

Load

ID,

LL * $(VV) as MM

Resident XYZ;

Re: Input Box and Calculations

alec1982 — Wed, 13 Nov 2013 19:56:51 GMT

Hi Michael,

This will not work as the variable is 0 when we load it at first then user will enter an amount on the variable..

Mainly this new field will be dynamic based on the user input..

Thxs,

Alec

Re: Input Box and Calculations

Anonymous — Wed, 13 Nov 2013 20:02:06 GMT

Badr,

In this case you shouldn't use it in the load script. Use it in the front end expressions (charts and other places where you can use expressions).

LL * VV

LL * $(VV)

Regards,

Michael

Re: Input Box and Calculations

alec1982 — Wed, 13 Nov 2013 20:24:21 GMT

Thank you Michael,

I didn't explain it correctly.. it is more complex

On the table I have:

Load

ID,

If(ID<>Previous(ID) and Key - Key2=1,AA,

(peek(LL)+ (Var(VV)/4)) + Peek(LL)) as LL,

Resident XYZ;

I am wondering if i can do this inside a chart instead of on the script?

Re: Input Box and Calculations

Anonymous — Wed, 13 Nov 2013 21:20:22 GMT

Interesting... you want your field to return expression which contains variable... Is it correct?

See this:

LOAD

ID,

LL,

If(ID<>Previous(ID), AA, // returns number

peek('LL') & '+($' & '(VV)/4) +' & Peek('LL')) as MM // returns expression text

RESIDENT XYZ

ORDER BY ID;

You can use the value of the MM field using dollar-sign extension, like $(=MM). Not sure about the details, give it a try.

Re: Input Box and Calculations

alec1982 — Thu, 14 Nov 2013 05:00:59 GMT

Hi Michael,

This is returning the value in the field as follow 4+$(VV)/4) +4 which is great..

Now I need to present it in a chart so I used the following formula

if(VV)=0,Sum(LL),Sum($(=MM)))

But it is not working..

Let me know your thought and thxs for all your help!

Thxs,

Alec

Re: Input Box and Calculations

tresB — Thu, 14 Nov 2013 06:29:42 GMT

Could you post your sample app?

Re: Input Box and Calculations

alec1982 — Thu, 14 Nov 2013 15:46:02 GMT

Hi,

Attached is a copy of the QVW.

the value that I am trying to show is inside the blue text box. It works only if one Quarter is selected while I needed to work for all of them so i can put it in a chart..

Thxs for your help!

Alec

Re: Input Box and Calculations

alec1982 — Thu, 14 Nov 2013 22:29:19 GMT

Hi Any body can help on this..

Thxs so much!

Alec