topic Re: Issue with Inputfield in QlikView

Issue with Inputfield

NavinReddy — Thu, 14 Nov 2013 15:09:02 GMT

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

Re: Issue with Inputfield

Aurelien_Martinez — Thu, 14 Nov 2013 15:20:54 GMT

Hi,

You want to divide Values1 by TMB1?

If is that you can try :

Values1

/$(TMB1)

on Straight Table expression.

Regards,

Aurélien

Re: Issue with Inputfield

NavinReddy — Thu, 14 Nov 2013 15:38:32 GMT

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

Re: Issue with Inputfield

Aurelien_Martinez — Thu, 14 Nov 2013 15:59:44 GMT

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?

Re: Issue with Inputfield

Clever_Anjos — Thu, 14 Nov 2013 16:10:38 GMT

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

Because, you´re calculating those values at script level

Re: Issue with Inputfield

NavinReddy — Thu, 14 Nov 2013 16:46:14 GMT

Hi,,,

Yes i am reloading

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

Re: Issue with Inputfield

NavinReddy — Thu, 14 Nov 2013 16:58:45 GMT

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