Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How can we create a dynamic field in the frond end?

How can we create a dynamic field which is calculated from the existing fields in the data and again it gets validated based on a user input?

15 Replies
Gabriel
Not applicable

Re: How can we create a dynamic field in the frond end?

Hi,

Do you mind attaching sample file? Or expand on what you want to achieve

sunny_talwar
Not applicable

Re: How can we create a dynamic field in the frond end?

Would you be able to share some more information regarding what you are trying to achieve here...

Best,

Sunny

jontydkpi
Not applicable

Re: How can we create a dynamic field in the frond end?

Hi

Your requirement is still not that clear. If you want to upload sample data, I would reduce the size significantly. I suggest that you upload a qvw document showing what you have at the moment, and whet you need to achieve.

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
bhagirath
Not applicable

Re: How can we create a dynamic field in the frond end?

you can create derived dimension or calculated list box this will be getting calculated at object calculation time

but you can not physically store some field in your data on run time

Not applicable

Re: How can we create a dynamic field in the frond end?

Hi Jonathan,

Attached a sample QVW,what I would like to see is the Sum changes based on the input box value.

bhagirath
Not applicable

Re: How can we create a dynamic field in the frond end?

and what exactly you want to enter in input box ?
i mean where you want use vInput in calculation ?

sunny_talwar
Not applicable

Re: How can we create a dynamic field in the frond end?

Is COMMON and UNCOMMON are the user inputs? Until we know what the user inputs and what exactly he needs to see once he inputs something, we won't be able to help much.

Best,

Sunny

Not applicable

Re: How can we create a dynamic field in the frond end?

The user input will be a numeric value based on which the field Trigger is validated using the condition IF((G2-AVERAGEIFS(B2:B10,F2:F10,"Yes"))>Sheet2!A1,"YES","NO")

bhagirath
Not applicable

Re: How can we create a dynamic field in the frond end?

if(Trend-Avg({<Flag={'Yes'}>}Days)>vInput,'YES','NO')