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: 
BonganiButh
Contributor III
Contributor III

Filtering Calculated Fields in Charts

Hello Everyone. 

Please can you assist with the below. 

I have created a calculated field(Using an IF statement that essential compares two expressions) as seen in the screenshot below. What I require is 

1.  show only the results where = 1 ( As the calculated field has 0s/1s)

2. Selecting the top 5 results from the 1s.

Expression Used :  

IF(Aggr(COUNT({<[demand.bpart_gcl_id] = {'Labor'} ,
[demand.bpart_id] = {'PRIMARY ASSIGN'} ,
order_type_id = {'repair_order'},[service_call.rcode_id] =- {'Z31'}, [service_call_env.resolve_date_time.autoCalendar.MonthsAgo] = {0} >} order_id),[service_call_env.sa_person_id]) >=
[productivity_target.prod_target] * (Day(today())),1,0)

 

BonganiButh_0-1623258897774.png

I have tried using  variables,set analysis and the 'Show Column If' feature but no luck as yet. I am not sure if this can be done in the charts or is it something I need to do in the data load editor?

Your assistance will be highly appreciated.

Thanks in advance. 🙂 

 

0 Replies