Unexpected selection behavior

esklimkin — Fri, 30 Sep 2016 00:00:55 GMT

Dear colleagues

Need your help in resolving an issue below

I have 2 tables in data model:

FactTable with fields Date, Store and Value. There are some values for each store and each date.

Calendar with fields Date, Year, HalfYear, Quarter and Month (generated based on date from FactTable)

End-user wants to analyze data in a such way:

Step 1) Select one store

Step 2) Select current period - Year, HalfYear, Quater and Month. Analyze current period

Step 3) After analysis of current period, switch filter "Month" to previous/next month (e.g. apr to mar, jun to jul and so on)

The problem is:

After switching selection of "Month" filter to month, that is not in selected "Quarter" or "HalfYear" (e.g. apr to mar, or jul to jun), selection in filter "Stores" became clear.

Filters "Quarter" and "HalfYear" is cleared too and I understand that (that's OK), filter "Year" remains selected.

I believe, that filter "Store" also should been selected (as in Step 1), because it NOT contradicts to a new selection (there are value for each store and each month).

Why Qlikview has such a behavior? How can I avoid it? What is the logic of selection behavior?

Tested in QV 11.2 and QV 12.

Look at attached app example and screenshots

P.S. Data model simplified. In fact, there are 7-10 filters (e.g. Region, Salesman, Product and so on) and they all become cleared

topic Unexpected selection behavior in QlikView

Unexpected selection behavior