topic Re: Mashup query in App Development

Mashup query

Mahamed_Qlik — Tue, 12 Sep 2023 03:52:16 GMT

Dear all,

There is requirement to create mashup page from existing application with default max month and max year to be selected.

In application, default showing all year and month data which should be keep as it is but while showing chart from this application into mashup page the always selected year and month to be max.

is it possible ? how?

kindly suggest.

Re: Mashup query

ajaykakkar93 — Tue, 12 Sep 2023 05:45:05 GMT

Hi,

You need to take certain steps to achieve this,

Create a variable with max Month & year accordingly
reload the application
Visit Variable API & use getByName method: Variable API
Store the values in javascript variables
Visit Field API & use selectValues method: Field API
set the javascript variable with max Month & Year

Follow the above steps & value will be selected by default while mashup HTML is loading

Re: Mashup query

Mahamed_Qlik — Tue, 12 Sep 2023 08:14:54 GMT

Hi Ajay,

Thank you for your response. Here I have created and want to check if its correct as per your steps:

Create a variable with max Month & year accordingly - vMaxYear, vMaxMonth created in app and reloaded the app ( vMaxYear = Max(Year) & vMaxMonth = Max(Month) )
reload the application - app reloaded and published
Visit Variable API & use getByName method: As below script
Store the values in javascript variables : As below script
Visit Field API & use selectValues method: Field API : As below script

Re: Mashup query

ajaykakkar93 — Wed, 13 Sep 2023 03:03:37 GMT

Hi,

Change below to:

var app = qlik.openApp('APPID_HERE', config); //max year -> do the same for month OR can use YearMonth & get a max out of it app.variable.getByName('MyVarName').then(function(model){ console.log(model,model.layout.qText); // this will give you the result capture it & then store it in variable app.field("FieldName").selectValues([model.layout.qText], true, true); },function(errorObject){ console.log(errorObject); } );

Re: Mashup query

Mahamed_Qlik — Wed, 13 Sep 2023 03:41:56 GMT

Hi Ajay,

This is how changed but still I am getting all the values in year filter:

Re: Mashup query

edwin — Wed, 13 Sep 2023 13:01:01 GMT

this means your select is failing - is year a number or string? try using qNum instead of qText

Re: Mashup query

Mahamed_Qlik — Thu, 14 Sep 2023 03:04:53 GMT

Hi edwin,

This is my final js code, I have changed qtext to qnum but no luck so far:

Re: Mashup query

ajaykakkar93 — Thu, 14 Sep 2023 04:22:22 GMT

Hi,

Please verify the below

Year is a variable or its a field name, if it is a field name you need to add it in double quotes ("...")
Check if statically providing the value of Year let's say 2023 if that selects for you
app.field("Year").selectValues([2023], true, true); // OR try app.field("Year").selectValues(["2023"], true, true);
Based on this you will understand if the value is in Num or Text & you choose the select value statement accordingly

Final code:

Re: Mashup query

Mahamed_Qlik — Sun, 17 Sep 2023 04:03:35 GMT

Hi Ajay,

Thanks. This code works for me .

var a = parseInt(model.qContent.qString);
		console.log(model.qContent.qString,a);

Re: Mashup query

emma22 — Sun, 17 Sep 2023 18:11:03 GMT

Hello everyone, I often read your stuff and actively participate in this conversation. Check out this page as well. accessmcd