topic Re: how to isolate / unlink data in qlik sense in App Development

how to isolate / unlink data in qlik sense

crlesmes — Thu, 27 Sep 2018 19:26:28 GMT

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

Re: how to isolate / unlink data in qlik sense

undergrinder — Fri, 28 Sep 2018 08:00:38 GMT

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/ScriptRegularStatements/Quali…

Example:

Qualify *;

Load

From table1;

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

Re: how to isolate / unlink data in qlik sense

crlesmes — Fri, 28 Sep 2018 15:50:24 GMT

hello, gabor thanks for your prompt response

these 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

Re: how to isolate / unlink data in qlik sense

undergrinder — Mon, 01 Oct 2018 06:54:24 GMT

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.

Re: how to isolate / unlink data in qlik sense

crlesmes — Mon, 01 Oct 2018 15:05:45 GMT

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