Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sujeet_shirude
Creator II
Creator II

Filtering data based on measures

Hi everyone,

I have a data set similar to attached. I have created a master measure for sum(Sales Amount). In a table, I want to be able to enter greater than, less than or equal to value in the sum(Sales Amount) and filter the data. 

What will be the best way to do this? 

Any insights on this would be appreciated. Thank you!

 

Regards,

Sujeet Shirude

 

 

 

Labels (1)
1 Solution

Accepted Solutions
SerhanKaraer
Contributor III
Contributor III

Hi Sujeet,

You can convert an expression into a dimension with the help of Aggr() function.

Aggr(sum(Sales Amount),yourDimensionsToCalculateExpression)

By this way you can provide filtering option for users.

 

 

View solution in original post

2 Replies
SerhanKaraer
Contributor III
Contributor III

Hi Sujeet,

You can convert an expression into a dimension with the help of Aggr() function.

Aggr(sum(Sales Amount),yourDimensionsToCalculateExpression)

By this way you can provide filtering option for users.

 

 

View solution in original post

sujeet_shirude
Creator II
Creator II
Author

Thanks a lot, Serhan!

It worked.