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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
NavinReddy
Creator II
Creator II

Pivot Table

Dear All,

I created one Pivot table with one cycle group

its showing all business values but i want to show only 3 business only

=sum({<[New Level 1]=' Admin' or 'Ops' or 'Tech'>} [ Open Calls])

this expression not working

i want to filter These 3 only

where can i apply filters Group wise or Expression wise

Please guide me some one

Thanks In Advance

Niru

10 Replies
MK_QSL
MVP
MVP

What is in your cyclic group?

can you provide some 10 lines sample (dummy) data with same field name and Cyclic Group?