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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mahnoor1279
Contributor III
Contributor III

How to use measure expression as a dimension or in a filter

Hello everyone ,

IF(SUM({<[TRANSACTION_TYPE] = {'SALE'}, [NET_AMOUNT] = {">=5000000"}>} [NET_AMOUNT]),'GREATER','LESS')

 

i've this  expression and i want to use this as a dimension or as a filter in dashboard ,

 

Labels (5)
1 Reply
sidhiq91
Specialist II
Specialist II

@mahnoor1279  May be you can try to create a flag using the same expression in your load script something like below:

Load *,

if(([TRANSACTION_TYPE] ='SALE' and sum([NET_AMOUNT])>=5000000),'GREATER','LESS) as Flag

From Table_Name

Group by Fields;

In the front end you can use the Flag as a filter or Dimension.

If this resolves your issue please like and accept it as a solution.