Using 2 dimensions on a graph with 2 expressions

[#1]

Hi

I want to know if it is possible to make a graph with 2 lines on it and then use dimensions to split the lines out. So I have 2 tables something like this

Item Number	ASDA	Tesco	Price Date
1	10	12	Jun 2012
2	15	18	Jun 2012
3	20	24	Jun 2012
4	25	30	Jun 2012
1	11	9	Aug 2012
2	16	15	Aug 2012
3	25	21	Aug 2012
4	30	27	Aug 2012

Item Number	Size	Colour
1	Small	Green
2	Large	Green
3	Small	Blue
4	Large	Blue

So my graph has 2 lines on it average ASDA price and average Tesco Price with the dimension price date to see how prices change through time. I then want to be able to easily split these lines up so I can see how prices of small and large change at tesco and asda so there would be 4 lines on the graph and then be able to click and see how different colour prices change through time too. On graphs with just one line I have been able to do this with a cyclic second dimension so I can just change that dimension and the lines are grouped by whatever the second dimension is but I have found when I have 2 expressions Qlikview will not do this.

Hopefully that made some sense. Is there another way?

Thanks a lot

Richard

[#2]

could you send sample file?

[#3]

This should show the problem. The first graph has average tesco and average asda prices with a second cyclic dimension which does nothing whereas the second graph has just average asda price and a second cyclic dimension which allows you to rotate through the different field details and the average asda price is split up. Ideally I would have one graph with average asda and average tesco prices which are then split up by size or colour and I can just click a button to cycle through the dimensions. The actual file I'm working on has a lot more dimensions, this is just a simplified example.

Thanks

[#4]

i think it is imposible to do it

you can still do it by variable (and conditional show/hiden expressions) but with more dimension it would be dificult to provide