topic TY Vs LY Sales comparison status in QlikView

TY Vs LY Sales comparison status

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

Hi ,

We are comparing current year vs last year sales.

Here we need like if today(9/21/2017) sales is 100 and last year(9/21/2016) sales is 0 (or) today's sales is 0 and last year sales is 100 then we need to put the status as In-Active.

Please find the attached Sample requirement design.

Is it is possible by using if Condition.

Thanks...

Re: TY Vs LY Sales comparison status

sunny_talwar — Thu, 21 Sep 2017 11:11:11 GMT

In the script? Yes, may be like this

If([2017 Sales] = 0 or [2016 Sales] = 0, 'In-Active', 'Active') as Status

Re: TY Vs LY Sales comparison status

nareshthavidishetty — Thu, 21 Sep 2017 11:17:02 GMT

Hi,

[2017 sales] is an sample column name and we need to derive sales dynamically based on year.

Thanks..

Re: TY Vs LY Sales comparison status

nareshthavidishetty — Fri, 22 Sep 2017 05:16:35 GMT

Hi,

Any clue..

Thanks..