Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think that you could set a flag during the loading of data, than use the flag in your chart.
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.
Here is an example
What about the example i sent you? Has it been helpful?