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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.