topic Alternate State Issues in QlikView

Alternate State Issues

Wed, 03 Jul 2013 10:30:35 GMT

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!

Re: Alternate State Issues

Wed, 03 Jul 2013 11:14:20 GMT

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.

Re: Alternate State Issues

Wed, 03 Jul 2013 11:23:52 GMT

i think, try this

dimension=NameProduct

expression1= if(Flag_Type=1,IdProduct)

expression2= if(Flag_Type=2,IdProduct)