Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

chart

Hi,

how to make expression value as input value as i attachment in straight table.

6 Replies
Not applicable
Author

Hi,

   If I understand your question correctly then follow these steps:

1. Create one variable and write Allocation field expression on that (which you wrote in straight table).

2. Add input box object and set created variable on it.

3. Now whenever you change your filter, input value will also change as expression value.

Hope this will help you

Regards,

Ashutosh

sibin_jacob
Creator III
Creator III

HI Ramesh,

Please find the attached application.I used a input filed to enter the values inside a straight table and calculate based on the inputs.

Please let me know if you need any additional details.

Thanks,

Sibin Jacob.C

Not applicable
Author

Hi,

This is my contact number 8746078764......

Please provide me the contact no....i have some doubts

Not applicable
Author

Hi,

I need to enter the values to the table box manually.for this i am using 'INPUTFIELD' fields .when i am using this the expression is not working.i need both requirement .please find the attachment .and help me out this

Not applicable
Author

Hi sibin,

I am using personal edition.so,please tell me how u did,or attachment word doc or any code

Thanks very much

Ramesh

sibin_jacob
Creator III
Creator III

Hi Ramesh,

Sorry for replying so late, I was on a vacation. Please find below the script and expression.

Qualify*;
INPUTFIELD Data.Test;

Directory;
Data:
LOAD Produc_Name,1 as Test,Product_Values
FROM
Test.xlsx
(
ooxml, embedded labels, table is Sheet1);

Dimension is Data.Product_Name and expression is InputSum(Data.Test)

My contact number - 08951307704

Thanks,

Sibin Jacob.C