topic Re: Logical Help in QlikView

Logical Help

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to create a new column where New Not Traded where condition is

Customer Account Open Date = Opened in date period

Customer Type = Account or Cash

Sales Value is blank/null in date period

Customer Brand = J

left side are column name. can you pls help me in first and third requirement??

neelamsaroha157 — Mon, 10 Apr 2017 16:45:05 GMT

For the sales value blank you can use

either Isnull(date field)

len(Trim(DateField)) <1

neelamsaroha157 — Mon, 10 Apr 2017 16:46:06 GMT

Sorry, It would be 'Sales Value' filed NOT date field

Anonymous — Mon, 10 Apr 2017 16:48:16 GMT

and what about Customer Account Open Date

neelamsaroha157 — Mon, 10 Apr 2017 16:56:49 GMT

I didn't get what you meant by 'Opened in date Period', is it the range of dates???

How do you define 'date period'?

Anonymous — Mon, 10 Apr 2017 17:01:43 GMT

okk lets assume account which opened in current year and last year i.e2016 and 2017

neelamsaroha157 — Mon, 10 Apr 2017 18:20:39 GMT

May be

Year([Customer Account Open Date]) =Year(Today())

OR Year([Customer Account Open Date]) =Year(AddYears(Today(), -1))