Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to filter chart by a field value

Hi.

Im quite new to Qlikview, so please bear with me.

I have a chart of categories with comparison values from one year to the next. I've been asked to make 4 of these charts, one for each of our cost centers.

Im having trouble working out where to set the filter for each one.

The comparison chart was created by an outside consultant, so I've just copied it and changed the dimensions to show what I want to show.

Examples of our CostCenter's codes are SINT, STOUR and SSI. What code would I use, and where would I put it to set each table to a specific cost center.

I have attached 3 pictures of how the chart looks, and how the dimensions and expressions are set up.

Thank you.

Chart.jpg

Dimensions.jpg

Expressions.jpg

10 Replies
Not applicable
Author

You're welcome.

Glad to have helped you^^