Then, i am going to choose TxnMonth = 3 (March). After I made the selection, the selections that I made before were all cleared and the current dashboard only selected TxnMonth = 3, but for Japan, it indeed has transaction made in 2012 March. Why Qlikview cleared out my TxnYear = 2012 as well as Country = Japan? Does Qlikview treat this as a new search?
Ah, ok, I see what you mean. Yes, QlikView will clear all selections when you select something excluded like this, even though Japan would have transactions for the year 2012 for month 3 as well as Q2.
Because quarter = Q2 conflicts with month = March, so Qlikview clears the selection. Unfortunately that clears all the selections so the 2012 is cleared as well.
When you think about it, it could be quite complex and time consuming to work out which selection is causing the conflict, even though it seems obvious to us. This is a simple example, but in a complex case with many selections and large tables?
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein