topic Re: Help on expression in QlikView

Help on expression

Wed, 30 Jan 2013 13:59:55 GMT

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

Re: Help on expression

alexandros17 — Wed, 30 Jan 2013 14:27:05 GMT

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

Re: Help on expression

Wed, 30 Jan 2013 14:59:58 GMT

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.

Re: Help on expression

alexandros17 — Wed, 30 Jan 2013 15:57:01 GMT

Here is an example

Re: Help on expression

alexandros17 — Thu, 31 Jan 2013 09:27:38 GMT

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