Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

How to upload user input to Qvd with certain other constraints ?

Hi All ,

I want to update two user Input in Qvd .

But with following constrains ..

1) Data should be uploaded only when both input values are filled .

2) Date field should take system time stamp

3) After successful updated it should be reflected in table

4) After successful update it should trigger a mail as well . (shekhar.analytics@gamil.com)

Capture.PNG

Thanks & Regards

Shekar

13 Replies
shekhar_analyti
Specialist
Specialist
Author

antoniotiman‌ ... Help please !!

shekhar_analyti
Specialist
Specialist
Author

asgardd2
Creator III
Creator III

Hi!

A did not check it in trigger, but if you want change values in model you must use INPUTFIELD;

INPUTFIELD Input1,Input2;

Then if you want change Input1,Input2 click on symbol in the right side of object and enter a value.

shekhar_analyti
Specialist
Specialist
Author

Hi Anton ,

Thanks for the reply .

Actually my requirement is that , after entering both inputs when the user presses save then both these input should get updated in All Data table and also should get reflected in table , along with previous data .

I do not intend to replace existing data .

Can you please attach sample qvw ?

Thanks & Regards

Shekar

asgardd2
Creator III
Creator III

If you change value in inputfields , they only change in the current user session.

In order to use the button "Save", I think it is necessary to create 2 more such fields,like Input1_fix,Input2_fix (fictitious ones) and monitor the change of states Input1,Input2  + create a calculate condition for displaying the table.

shekhar_analyti
Specialist
Specialist
Author

Hi Anton ,

The solution you provided , though captures user input into table , but it overwrites existing value . Which should not be the case .

It should retain existing values and just append new inputs into the table

Capture.PNG

asgardd2
Creator III
Creator III

I think you can create two additional fields for user input, like Input1_fix,Input2_fix.

After reload app. field Input1 = Input1_fix, Input2 = Input2_fix.

After user input new value for Input1_fix and Input2_fix and push the button, value in chart is changed.

shekhar_analyti
Specialist
Specialist
Author

Thank for reply .. please attach sample qvw

asgardd2
Creator III
Creator III

Check the attachment.