topic Logical Help in QlikView

Logical Help

Anonymous — Thu, 30 Mar 2017 17:15:17 GMT

Greetings,

I want to add a column called "Traded" requirement is such that if a customer has traded with in its invoice date then it should show value 'Traded' else 'Not Traded'.

Re: Logical Help

vishsaggi — Thu, 30 Mar 2017 17:21:04 GMT

What is the field used here for CustomerTradeDate?

May be you can try like:

LOAD *,

IF(CustomerTradeDate <= InvoiceDate, 'Traded', 'NotTraded') AS TradeFlag

FROM yoursourcename;

Re: Logical Help

Anil_Babu_Samineni — Thu, 30 Mar 2017 17:21:17 GMT

May be this?

Load Field1, Field2, customer, [invoice date], If(customer <= [incoice date], 'Traded','Not Traded') as Traded

From <Datasource>

Re: Logical Help

Anonymous — Thu, 30 Mar 2017 17:26:39 GMT

there is no column such like date

Re: Logical Help

vishsaggi — Thu, 30 Mar 2017 18:19:56 GMT

So how you going to check if that customer is within the InvoiceDate, there should be some datefield right?

Re: Logical Help

MarcoWedel — Thu, 30 Mar 2017 22:59:12 GMT

It would help you to get answers if you provided information about existing fields in your data model instead of non existing ones ...