Alternate State Issues

[#1]

Hi,

I am working with two listboxes which have data from the same field.

My source table is like:

Product:

IdProduct, NameProduct, Flag_Type

0001 , Name1,  1

0002,  Name2,  1

0003,  Name3,  0

The two listboxes contain the Name Product, but each one is filtered by Flag type. So in ListBox1 I have products with Flag 1 and in ListBox2 I have products with Flag 0.

Now I have created a pivot table with the NameProduct as Dimension and I need to see the Products selected in both fields. I think the best aproach is with Alteranate States, but I still dont know how to set up the table.

Any ideas??

Thank you!

[#2]

In the qlikview examples there are alternate states, but these fields are not used as dimensions in the graphs/tables, so it is not very useful to me.

Thanks anyway.

[#3]

i think, try this

dimension=NameProduct

expression1= if(Flag_Type=1,IdProduct)

expression2= if(Flag_Type=2,IdProduct)