topic Re: Undesired filter in QlikView

Undesired filter

Wed, 01 Oct 2014 12:48:04 GMT

Hello,

On my sheet I have two tables using the same datas. The first one depends of all the selection made and the second only for one field (the name of the machine) (using set_analysis). So, whenever I change of selection of machine, the two tables changes. Moreover, in order to see the first table, a week number needs to be selected:

However, when I select a week number, something strange happen in the second table. Some datas seems to disappear, and therefore some expression are not calculating write:

Since all the different operations are not used every week, when I change of week; the operations in the second table that are not calculated corresponds to the operations not used that week. Since the second table is not supposed to take into consideration the selections, it is really weird.

I really don't understand what is going on in there 😕 Did this happen to anyone.

Here is the qvw file, but no data is on it. The concerned tab is the last one on the window.

Re: Undesired filter

Michiel_QV_Fan — Wed, 01 Oct 2014 12:57:27 GMT

I cannot help with this issue.

In the future, if you build a new app consider to do this in English. Asking help here and getting an answer will be easier in Englisch.

Re: Undesired filter

Wed, 01 Oct 2014 13:03:44 GMT

Well the data's are in English and I can't change it unfortunately 😕

Re: Undesired filter

Gysbert_Wassenaar — Wed, 01 Oct 2014 13:25:59 GMT

I think your calculated dimension is causing it. See attached qvw for another approach.

Re: Undesired filter

Wed, 01 Oct 2014 13:50:10 GMT

I see in your file that you removed the dimension and added a condition in the count function. I tried it with the data and it still doesn't work and the thing is that I need the dimension to remains like that, maybe another expression to get it, but I need the final view to be like that 😕