combined selections in straight table

[stefano_marson]

Hi to Everybody,

I'm working with QlikView vers. 9. I can't upgrade to 11.
I need to make a selection on a straight table. I want to consider only the rows with a value of -1 expression Semaforo. See attached Esempio.qvw. The graph consists of two dimensions, each of which is a cyclic group.

It is to select combinations defined by a value of the first dimension AND a value of the second dimension.

By making a selection (see selezione.JPG) the result is not as expected (see risultato_selezione.JPG), although it is consistent with the logic of QlikView.

I don't want define in script a new field for each combination of the fields of the two cyclic groups and use the appropriate field as a dimension. I have too many combinations to manage

Any idea on how to solve my issue?

Thank you in advance

Regards

[Gysbert_Wassenaar]

What you want is not possible afaik. The only way to do this is to create a new field in the script or to hard-code the selections in a set analysis expression.