Problem with dimension and if condition

Thu, 02 Oct 2014 07:05:53 GMT

Hello,

I have a problem and I am not so sure it has a answer, but if you know something please help!

table 1	Coolers	Department	% Share
			88,5%
	Refrigerator	invaded	88,5%
	Refrigerator	70% stock	88,5%

table2: what I have now	Coolers	invaded	70% stock	% Share
	Refrigerator	"red cross"	"red cross"	88,5%
	invaded	if(Department='invaded','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')
	70% stock	if(Department='70% stock','qmem://<bundled>/BuiltIn/check_g.png','qmem://<bundled>/BuiltIn/cross_r.png')

table 2: waht I want	What I want to see is :
	Coolers	invaded	70% stock	% Share
	Refrigerator	"green check"	"green check"	88,5%

If I had on table 2 the department included in the dimensions it would be like this
Coolers	department	invaded	70% stock	% Share
Refrigerator	invaded	"green check"	"red cross"	88,5%
Refrigerator	70% stock	"red cross"	"green check"	88,5%
This is correct, but I want to see it in just one line both with green check

Going back to table 2 :
Coolers	invaded	70% stock	% Share
Refrigerator	"red cross"	"red cross"	88,5%
If I introduce on the side a Department filter and select one of the two it will appear its green check
filter department: invaded selected
Coolers	invaded	70% stock	% Share
Refrigerator	"green check"	"red cross"	88,5%
Again what I expect is to see both on green since both are included in the coolers refrigerator type.

topic Problem with dimension and if condition in QlikView