Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
aheavy95
Creator
Creator

Alternate state inside measure

Hi all,

In a Dynamic table (Ad hoc reporting) I've created -

the user selects a store (green mark) , dimensions a measure (black)

And as a result-  only stores that have the same values as the store selected (green)  in these dimensions (FC, TENBIS in this case) , are shown in the table. (implemented with alternate states)

aheavy95_0-1697367034446.png

In one of my dimensions- Area, instead of showing restaurants with the exact number only, I want to show the ones that are in the range(of +-20) of the selected store's area. 

This is how the dimension field is implemented  (same for all). What should I add in order to achieve this? 

=Aggr( Only( {StoreComp1} BrutoArea), BrutoArea)

{StoreComp1} is the reference to the alternative state 

 Thanks

 

Labels (5)
0 Replies