Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Annie2
Contributor
Contributor

Can measures be used for filtering data like dimensions

 Hi @mbj , @richbyard , @pawwy1415,@ErikWetterberg,@rohitk1609,@Mp3Leaks,@petter  I have created AD HOC Sheet in Qlik Sense. I can filter the data using dimensions but i am unable to filter data using measures. Is there any solution where both measures and dimensions can be used to filter the data based upon the user convenience. Apart from AD HOC Sheet, let me know if we can implement it in any view like Pivot or Straight Table etc.                                                                                                                                                     Please find below screenshot of AD HOC Sheet. In the below sheet we can filter the data using dimensions as highlighted. Let me know is there any solution whether measures can be used to filter the data.

Annie2_0-1721293396133.png

 

Labels (3)
1 Solution

Accepted Solutions
G3S
Creator III
Creator III

for measures, you cannot filter in the pivot. but it is possible to have them in the filter pane. perhaps that would work? 

 

View solution in original post

1 Reply
G3S
Creator III
Creator III

for measures, you cannot filter in the pivot. but it is possible to have them in the filter pane. perhaps that would work?