Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

exclude data in charts based on filtering

I'm approaching Qlik sense but I have difficulty with the syntax.

I have a data table with the following fields:

- company code (only 2 values: firm1 and firm2)

- client code

- year

- amount

I created a chart that shows me the values by year and everything works correctly.

Now I would like to exclude some customer codes when I select both companies on the filters.

I tried to write a condition in the chart but I can not find the correct syntax or write it in the wrong place.

Can someone help me?

Thank you so much

1 Reply
isingh30
Specialist
Specialist

Can you share some sample? What codes you want to show or hide. This can be done in multiple ways - Using if statement or only function in set analysis.