Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Niru
Contributor II

Issue with Inputfield

Hi All,

I have an issue

i have one inputbox and tablebox

if i enter 100 in inputbox it will calculate as per my equation in tablebox,

here i need to edit the values in values for that im using script in inputfield ,

here im facing the issue if i give 100 in inputbox its not working and it not calculating the values

Some one help me Please find the Screen shoot and QVW

Thanks ,

Niranjan

6 Replies
amartinez35
Valued Contributor

Re: Issue with Inputfield

Hi,

You want to divide Values1 by TMB1?

comm.png

If is that you can try :

Values1

/$(TMB1)

on Straight Table expression.

Regards,

Aurélien

Niru
Contributor II

Re: Issue with Inputfield

yes ,but if i use inputfield in script ,

in dashboard if i enter values in inputbox tablebox values are not changing

help me

Thanks,

Niranjan

amartinez35
Valued Contributor

Re: Issue with Inputfield

Try this script:

LET Newspaper1=round($(TMB1)*2/100);

LET Onlineadvertising1=round($(TMB1)*20/100);

LET Searchspends1=round($(TMB1)*20/100);

LET Trailers1=round($(TMB1)*20/100);

LET Banners1=round($(TMB1)*1/100);

LET OOH1=round($(TMB1)*5/100);

LET Displays1=round($(TMB1)*4/100);

LET Theatrespends1=round($(TMB1)*5/100);

LET TVNational1=round($(TMB1)*20/100);

LET TVregional1=round($(TMB1)*3/100);

Movie1:

LOAD * INLINE [

Spends1,Values1

    Newspaper, $(Newspaper1)

    Online advertising, $(Onlineadvertising1)

    Search spends, $(Searchspends1)

    Trailers, $(Trailers1)

    Banners, $(Banners1)

    OOH, $(OOH1)

    Displays, $(Displays1)

    Theatre spends, $(Theatrespends1)

    TV National, $(TVNational1)

    TV regional, $(TVregional1)

];

INPUTFIELD Values2;

NoConcatenate

Movie2:

LOAD

  Spends1,

  Values2

Resident Movie1

;

Drop Table Movie1;

That you want?

Employee
Employee

Re: Issue with Inputfield

Are you reloading your app, when you change the value?

Because, you´re calculating those values at script level

Niru
Contributor II

Re: Issue with Inputfield

Hi,,,

Yes i am reloading

and i tried same problem in front end expression using table box,same problem i am facing 

Niru
Contributor II

Re: Issue with Inputfield

Hi All,

previous if i enter any value in inputbox it will share percentage wise

now if i enter any value in inputbox not working plz find the attachement

Thanks

Niranjan

Community Browser