topic Re: Mashup getContent function in Management & Governance

Mashup getContent function

marco_puccetti — Fri, 13 Nov 2015 10:50:29 GMT

Hello, i need to get, from a mashup web application, a variable content.

This variable is computed in this form:

Date(Date(Max([Data Decorrenza]) + 1) + (0 - Sum([Importo Lordo Rata]))/Money(Round(Sum([Importo Lordo Rata]) / Round(max([Data Decorrenza]) - min([Data Decorrenza])))))

the problem is that using the app.variable.getContent, the result is the above expression and not the date value i expect.

Anybody knows how to get the computed variable content?

Thanks

Marco

Re: Mashup getContent function

reddy-s — Fri, 13 Nov 2015 11:48:32 GMT

Hi Macro Puccetti,

Based on the explanation you have given, looks the you have declared a variable with the above expression.

When you use app.variable.getContent ,it it will only return the string value like it has done. For you to get the expression valuated, create a hypercube with one measure and pass the string value from app.variable.getContent to the hypercube and this gives you the calculated values of the expression.

If its just a dimension try using the field list instead of a hypercube.

Hope this is helpful.

Regards,

Sangram Reddy.

Re: Mashup getContent function

marco_puccetti — Fri, 13 Nov 2015 12:03:34 GMT

But i need to populate an html input field with the computed variable, so which api have i to use?

Can you make me an example?

Another thing on Qliksense when i use the Let statement to set the variables values i've noticed the content of the variable is blank how can be? I need this content into the mashup application.

Thanks

Marco

Re: Mashup getContent function

reddy-s — Fri, 13 Nov 2015 17:49:07 GMT

Hi Marco Puccetti,

Here is what you need.

Firstly declare a variable in your script like this:

Then Create an input box(Or any other element you would like to bind the output to):

Create a hypercube by reffering to your variable:

Update the field in the UI in the function as done above.

You should see the Input field update after the function is updated

Hope this helps.

Thanks and Regards,

Sangram Reddy.

Re: Mashup getContent function

marco_puccetti — Mon, 16 Nov 2015 11:20:29 GMT

Ok, but i also need an onClick function that allows me to update an input text with a computed variable depending on the first input text variable. Is it possible?

Thanks

Marco

Re: Mashup getContent function

reddy-s — Mon, 16 Nov 2015 11:45:16 GMT

Hi Marco,

As this would be a selection,

Just simply use the below code to trigger a selection inside the previous code :

function(reply){

//....... Your code from after you fetch the data from the hyper cube.

$("#buttonId").click(function() {

app.field("[<Name of the field>]").selectMatch(<Value of the input field>, false);

});

}

This code triggers a selection and hence re-generates the hypercube with the filtered result.

- Sangram Reddy

Re: Mashup getContent function

marco_puccetti — Mon, 16 Nov 2015 13:38:08 GMT

I have created on qliksense an input text in which i have printed a variable value, so what have i to use to get that field content if i don't know exactly it?

I have tried the selectAll method but i don't find the prototype.

Thanks

Marco

Re: Mashup getContent function

reddy-s — Mon, 16 Nov 2015 13:45:28 GMT

Hi Marco,

Make sure your input box has an ID assigned and then use the below code to fetch the value you have in an input field.

$('#ID').val()

- Sangram

Re: Mashup getContent function

marco_puccetti — Mon, 16 Nov 2015 13:58:30 GMT

I mean that on Qliksense i have a text field containing a variable value, so i need to get that value in a mashup application within an input file (as showed in the above posts).

Below the screen. How can i obtain what i desire?

Thanks

Marco

Re: Mashup getContent function

reddy-s — Mon, 16 Nov 2015 14:43:57 GMT

Hi Marco,

Ok, So when you input a value into "importo Previsione" field in your mash up, the value in the text field in Qliksense which uses $(m_data_fine_previsione) variable has to be returned. Am I right?

If so,

just replace "qDef": "$(VALUE_Y)" with "qDef": "$(m_data_fine_previsione)".

Now when you click on the "Raggiungibile il" button call this:

$("#buttonId").click(function() {

app.field("[<Name of the field>]").selectMatch(<Value of the input field>, false);

});

Doing this the hypercube gets the respective value for the value provided in the text field in Qliksense by executing the $(m_data_fine_previsione) expression.

If you need the properties of any Qliksense object(As in your case , text of an element ), just make use of :

app.getObjectProperties("CFyDy").then(function(model){

console.log(model);

});

Where "app" = instance of the app in which the object exists in.

Here "CFyDF" is the object ID of the text element in Qliksense.

You can get the ID from the single object browser:

Thanks and Regards,

Sangram Reddy.

Re: Mashup getContent function

marco_puccetti — Mon, 16 Nov 2015 15:52:55 GMT

$("#buttonId").click(function() {

app.field("[<Name of the field>]").selectMatch(<Value of the input field>, false);

});

How have i to use this function if i need the text element value and i don't know the content?

Thanks

Marco

Re: Mashup getContent function

marco_puccetti — Mon, 16 Nov 2015 16:10:45 GMT

Perhaps the getContent function should function also on complex variable and not only on simple numeric content?

Any ideas?

Thanks

Marco

Re: Mashup getContent function

reddy-s — Mon, 16 Nov 2015 16:16:12 GMT

Hi Marco,

Just create a field list and make use of the function to select the value from the input field.

Re: Mashup getContent function

reddy-s — Mon, 16 Nov 2015 16:17:05 GMT

Marco Puccetti wrote:

Perhaps the getContent function should function also on complex variable and not only on simple numeric content?

Any ideas?

Thanks

Marco

Haven't tried it ever.Got to check.

Re: Mashup getContent function

marco_puccetti — Tue, 17 Nov 2015 09:24:50 GMT

I need a function to get a variable content or field content from a button trigger function.

Thanks

Marco

Re: Mashup getContent function

marco_puccetti — Tue, 17 Nov 2015 11:47:27 GMT

I have noticed that the setContent function works perfectly, while the getContent seems to not enter the callback function.

This is the statement:

app.variable.getContent('$(variable_name)',function ( reply ) {

var sTemp = JSON.stringify( reply );

var json_parsed = JSON.parse(sTemp);

sTemp = json_parsed.qContent.qString;

$("#OBJ_ID").val(sTemp);

} );

This statement is inserted into a javascript onClick routine.

I expect to get the variable value, isn't it?

Thanks

Marco

Re: Mashup getContent function

marco_puccetti — Tue, 17 Nov 2015 13:58:35 GMT

It seems that $(variable_name) within the getContent function doesn't work.

So how can i get a variable content using the getContent function for a variable of this type:

SET variable = Date($(date_1) + $(date_2));

Thanks

Marco