topic Re: Bar chart with restriction in QlikView

Bar chart with restriction

Wed, 14 Jan 2015 05:35:05 GMT

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

Re: Bar chart with restriction

Wed, 14 Jan 2015 05:45:21 GMT

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).

Re: Bar chart with restriction

its_anandrjs — Wed, 14 Jan 2015 05:46:02 GMT

Hi,

Try this

Dim:- Country , Color

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

Regards

Anand

Re: Bar chart with restriction

Fri, 16 Jan 2015 04:52:24 GMT

Hi Anand,

Thank you for your response.

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

Regards,

Lily

Re: Bar chart with restriction

Fri, 16 Jan 2015 09:37:36 GMT

Hi Aanad,

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

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