Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Help on expression

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

4 Replies

Re: Help on expression

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

Not applicable

Re: Help on expression

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

Here is an example

Re: Help on expression

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

Community Browser