topic Re: Mashup and multiple apps in Integration, Extension & APIs

Mashup and multiple apps

shayraber — Tue, 22 May 2018 14:09:53 GMT

hi,

i'm new to QlikSense and have created two separate apps, one for sales and one for finance.

Both apps have common fields such as BU (Business Unit), Calendar, etc.

Now, I've created a mashup involving objects from both apps and facing the following issue:

assuming i have a table of sales summary per BU (from sales app) and a bar chart for organization expenses per period and BU (from finance app).

when i'm selecting in the mashup a BU from the the sales table the table is filtered accordingly BUT the chart from the finance app which also contains a BU field - DOESN'T filtered.

is that the right behaviour?

is it possible to combine objects from different apps and they will effect each other when it comes to common fields?

of course, when i'm making selections in fields which are NOT common I'm NOT expecting that one object's selection WON'T effect objects from other apps.

Regards,

Shay

Re: Mashup and multiple apps

ErikWetterberg — Tue, 22 May 2018 15:30:40 GMT

Hi,

That's the way it works, selections are made in one app. If you want them to be coordinated between apps you need to write some code for that. Alternatively merge the two apps and Qlik Sense will take care of it for you.

Erik Wetterberg

Re: Mashup and multiple apps

shayraber — Wed, 23 May 2018 06:08:21 GMT

If you want them to be coordinated between apps you need to write some code for that

Hi Erik, thanks for your quick reply

did you mean HyperCubes?

just saw an older post regarding that issue which I didn't understand what should be done in order to handle it.

didn't mean to get a 'step-by-step' guide but a high level description of the steps that are required in order to achieve that solution.

Regards,

Shay

Re: Mashup and multiple apps

Anonymous — Tue, 29 May 2018 01:18:04 GMT

We had a similar situation. Here is what we did.

1. Classify one app as primary and another app as secondary.

2. Show the filter component from the primary app that has the common filters

3. add listener to listen to the selection event

4. In the listener, pass the selection values to the secondary app

What you will lose? selection on chart objects from secondary app will not reflect on the primary app. We negotiated with customers to make selections from the filter components and disabled selections on those chcarts

What you gain? No overhead of writing custom filter components and hence no worry about performance.

We have a sample project created in GitHub: https://github.com/CodeAtRoost/Qliksense_Selection_between_apps/blob/master/README.md

Please check it out. Its made using the Help desk Management qvf which is one of the default apps with Qlik. So you will not have any issues testing it out. There is a detailed explanation of the code as well.

If you do not want to disable chart selections, then you have to build custom filter components.

Regards

Nivedha

Re: Mashup and multiple apps

ErikWetterberg — Tue, 29 May 2018 10:40:38 GMT

Hi,

Basically you need to listen to selections in one app, probably using ListObjects. When the contents of the ListObjects change, you need to make the corresponding changes in the other app. You can do that with field.select.

I assume that you only allow selections in one of the apps. If you transfer selections in both directions, it's much more complicated.

Erik Wetterberg

Re: Mashup and multiple apps

mauricio_minate — Fri, 01 Jun 2018 17:56:07 GMT

Hi Nivedha, this extension is awesome! But i have a problem.

With number values the code transform to text and he can't filter the other app cause the value is a number.

I tried to add some lines os code that verifies if the value of the array is a number or a string but i dont succeed.

Can u help me?

This is what a wrote:

cacheString=cacheString + '@' + value.fieldName +"~" + value.qSelected;

var m = valArray

if(number(m)=NaN) {

app1.field(value.fieldName).selectValues(m);}

else{

m = number(m);

app1.field(value.fieldName).selectValues(m);

}

Re: Mashup and multiple apps

Anonymous — Mon, 04 Jun 2018 05:00:14 GMT

Hi Mauricio,

Please replace

valArray.push(value.qName); inside the listener function to

isNaN(value.qName) ? valArray.push(value.qName):valArray.push(Number(value.qName));

Please let me know if this works. Good catch, though!!

Regards

Nivedha

Re: Mashup and multiple apps

Anonymous — Mon, 04 Jun 2018 05:01:04 GMT

Yes Erik. The filter selection flows in one direction only.

Regards

Nivedha

Re: Mashup and multiple apps

Anonymous — Mon, 04 Jun 2018 05:08:04 GMT

You also may want to convert the valArray values into numbers if its a number dimension (using the same logic as above), in the retrieveSelectionfromCache() if you are using filter across pages.

Re: Mashup and multiple apps

mauricio_minate — Tue, 05 Jun 2018 00:17:51 GMT

Hi Nivedha,

First of all thanks for the quickly reply!

I replaced the "valArray.push(value.qName);" line inside the listener function and at first it worked.

But if i select a text and then i select a number the filter seems dont recognize the number. Or if i select a number and then a text, the filter dont recognize the text. This also happens when i make two text filters in a row.

If i go to code line, change something(can be a comma) and save, the app starts to recognize the filters...

Do u know what could be?

Re: Mashup and multiple apps

Anonymous — Wed, 13 Jun 2018 12:26:33 GMT

Hi Mauricio

Sorry for the late reply.

I could not replicate it. Did you try it on server or desktop?

Regards

Nivedha

Re: Mashup and multiple apps

dipankarm — Fri, 11 Jan 2019 04:59:49 GMT

Hi Nivedha,

Thanks for your solution. So there is no way to achieve selections in the secondary app and have it reflect on the primary one? Have you done any enhancement to this project? I have a requirement of merging 2 different apps into one in a Mashup but I cannot really disable selections on the charts.

Thanks in advance!