Calculated Dimension No Gray Record Visible

[dberkesacn]

Hi All,

when I create a calculated dimension like ==> aggr(only({<myFavouriteCountry={'India'}>}City),City) and make a selection I dont see the gray options in the filter pane (where I made the selection), only the selected ones (with green...)

I would like to have this feature using front end expression, not backend script.

Thanks,

Dan

[JordyWegman]

Hi Dan,

What is the outcome, only the cities in India?

I think you don't see the gray options because your set analysis is forcing this.

Jordy

Climber

[dberkesacn]

that is my problem.

I wanna create a new dimension using only front-end expression which will shows gray values after selection.

D

[tresesco]

Try using IF instead of aggr and only(). Try like:

If(myFavouriteCountry='India', City)

Assuming myFavouriteCountry is a field.

[dberkesacn · Accepted solution]

with if() after selection, qlik displays in the selection ribbon myFavouriteCountry = India and the selected City as well.

having set analysis aggr() only()  combo worked if the identifier is 1.

aggr(only({1<myFavouriteCountry={'India'}>}City),City)

Dan