Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
crlesmes
New Contributor II

how to isolate / unlink data in qlik sense

Good day:

What happens is that in my model I have several fields that are related to each other and that come in the base, however I would like there to be several fields to do something like not to be modified. filter between them,

this is because in the base (EXCEL) there are certain cells with fields that only need to be related to each other (EXAMPLE: date and progress and type and type total) but in which sense the associations all as if only one (EXAMPLE: 1 January - 100% - book - 5), this really affects as it should not only show the data only in the following way (January 1 - 100%) & (book - 5) in such a way that it only shows me what it has to show as in the example

I thank you in advance for the prompt help

excuse my English so poor

4 Replies
undergrinder
Valued Contributor II

Re: how to isolate / unlink data in qlik sense

Hi Cristian,

If your tables have common field (based on name) the tables will be linked.

You can aliasing every column or use qualify, where every/particular field get the table name as prefix.

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptReg...

Example:

Qualify *;

Load

     a,

     b

From table1;

The field names will be table1.a and table1.b

G.

crlesmes
New Contributor II

Re: how to isolate / unlink data in qlik sense

hello, gabor thanks for your prompt response


img.pngthese fields need to be in the same model sheet but if I filter by date (EXAMPLE: January 1) I should not show the value of the TYPETOTAL field unless I filter it through the TYPE field, that's why my question is the data so that the filters made in the graphics do not interfere with each other

undergrinder
Valued Contributor II

Re: how to isolate / unlink data in qlik sense

So, If the two tables data shouldn't be interfere, then use qualify to unlink the tables.

When these tables have logical link, and wawnt to show the TYPETOTAL data, but after filter the date and the TYPE field, I suggest you to use the Calculation condition  that is present at many object.

You can catch the selections of field by Getselectedcount() function.

for example the calculation condition at the object with TYPETOTAL: =getSelectedCount(TYPE)>0, then the object appears only when the TYPE field is filtered.

G.

crlesmes
New Contributor II

Re: how to isolate / unlink data in qlik sense

good morning, garbot

Thank you very much for your answer, it was quite successful and if I worked to make the condition, in fact the fields were filtered only by the relationship that these should have.


I'm sorry for the inconvenience and I appreciate your punctual collaboration