topic LFL sales comparison expression in QlikView

LFL sales comparison expression

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

i want to implement a LFL sales comparison so for that i have expresiions for current year and previous year as following

current year

sum({< Sold_Year = {"$(=Max(Sold_Year))"}>} [inv value]/Sales_INR_Unit)

Previous Year

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit)

Before previous Year

sum({< Sold_Year = {"$(=Max(Sold_Year)-2)"}>} [inv value]/Sales_INR_Unit)

so i want expression for LFL sales comparison

expression :-

=num(

(

sum(Aggr(

if(

sum({< Sold_Year = {"$(=Max(Sold_Year))"}>} [inv value]/Sales_INR_Unit) > 0

and

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit) > 0 > 0,

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit)/100000)

,[StoreName]))

sum(Aggr(

if(

sum({< Sold_Year = {"$(=Max(Sold_Year))"}>} [inv value]/Sales_INR_Unit) > 0

and

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit) > 0 > 0,

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit)/100000)

,[StoreName]))

)-1

,'#,##0%')

but above following expression is not giving me any result

regards

saksham

Re: LFL sales comparison expression

shiveshsingh — Fri, 02 Feb 2018 12:00:19 GMT

Can u share sample app?

Re: LFL sales comparison expression

prma7799 — Fri, 02 Feb 2018 12:37:21 GMT

check this

=num(

(

sum(Aggr(

if(

sum({< Sold_Year = {"$(=Max(Sold_Year))"}>} [inv value]/Sales_INR_Unit) > 0

and

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit) > 0 ,

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit)/100000)

,[StoreName]))

sum(Aggr(

if(

sum({< Sold_Year = {"$(=Max(Sold_Year))"}>} [inv value]/Sales_INR_Unit) > 0

and

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit) > 0 ,

sum({< Sold_Year = {"$(=Max(Sold_Year)-1)"}>} [inv value]/Sales_INR_Unit)/100000)

,[StoreName]))

)-1

,'#,##0%')