10 Replies Latest reply: May 8, 2012 11:24 PM by Alexis Tan RSS

How to filter chart by a field value

John Reardon

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