Help on expression

[#1]

Hi All,

I have the below requirement in QlikView.

Table:

Valid Col1          Type             Key

---------------          -------             -------

Category1         Custom1         12

Category1         Category1       12

Category1         Custom1         13

Category1          -                    14

Category2         Custom2         15

Result:

Valid Col1          Type             Key

---------------          -------             -------

Category1         Custom1         13

Category1          -                    14

Category2         Custom2         15

I would like to display the result, when Validcol1 <> Type (or) null, but also the Key should not be the same i.e.,the reason why the first 2 rows are not displayed in the result is because the 2nd row has Validcol1=Type and the key is 12, but eventhough the first row is not valid, the key is valid, hence don't want to display it in the result.

Can someone, please help me with the expression for the above criteria. Thanks in advance.

Thanks

Sam

[alexandros17]

I think that you could set a flag during the loading of data, than use the flag in your chart.

[#3]

Thanks Alex. Can you please show some more light on this issue?. A little explanation would be helpful for me to implement. Appreciate your time.

[alexandros17]

Here is an example

[alexandros17]

What about the example i sent you? Has it been helpful?