Qliksense |Ignoring all the selections

[Karim_Khan]

Hi,

I was trying to ignore all the selections when we make any filter selection and my data value in text box remain constant.For simple expression its working but when am trying to go with dynamic expression its not working.

For example : If i select any division value then one of source system get removed from text box value and if i unselect division it arrives back into text box.

Concat( Aggr( Date( Max({1} LATEST_DATE), 'DD/MM/YYYY' ) & ' (' & Only({1} DB_SYSTEM) & ')', DB_SYSTEM), ', ' )

I tried with alternative option i.e Applybook mark when opening the home page but it will reset other selection that we made on other sheet and need to redo it.

[priscilarubim · Accepted solution]

Hi Karim,
Could it be that {1} isn't propagating to the Aggr() dimension itself? It's correctly applied inside Max() and Only(), but the DB_SYSTEM used as the Aggr dimension still respects the current selection state, so when a Division is selected, some DB_SYSTEM values drop out of the possible set and the Aggr stops iterating over them.

[Karim_Khan]

Hi Priscila,

Well in that case I presume that Concat +  Aggr is not going to work with current selection becuase of DB_SYSTEM dynamic associated values.

Then this code won't fulfill the purpose need to go with other way around with some more tweaks.