Bar chart with restriction

[#1]

Hi there, I am new to Qlikview, hope you can help me  out here.

I would like to show say total shoes sale data for all country and Yellow colour and size 39

In a bar chart, How do i do the restriction?

Thanks in advance.

Country	Colour	Sales	size
USA	Yellow	12	40
USA	Red	20	37
UK	Yellow	8	39
Japan	Black	15	35

[#2]

hope you have loaded data first right click on a sheet and create new sheet object, then select chart and by default it will be bar char selected,otherwise select the first option . then add colour as a dimension and the go the expressions tab and a new expression  sum(sales).

[its_anandrjs]

Hi,

Try this

Dim:- Country , Color

Expr:- sum( {<Colour -= {'Yellow'}, size -= {'39'} >} Sales)

Regards

Anand

[#4]

Hi Anand,

Thank you for your response.

Is there a tutorial specificly show you how to create different expression?

Regards,

Lily

[#5]

Hi Aanad,

I have used the same expression in my bar char but it is not working.

=sum( {<Color -= {'Yellow'}, size -= {'39'} >} Sales)