topic Re: Expression in QlikView

Expression

smilingjohn — Fri, 26 Feb 2016 13:17:45 GMT

Hi All,

Can any one explain me what is the meaning of the below expression. what this expression will ?

count({<Date={">=$(=AddMonths(Today(),-6))<=$(=Today())"}>}DISTINCT Product)

Regards

John

sunny_talwar — Fri, 26 Feb 2016 13:21:51 GMT

This expression means:

Count all distinct products which are available within last 6 months

alexandros17 — Fri, 26 Feb 2016 13:21:53 GMT

count({<Date={">=$(=AddMonths(Today(),-6))<=$(=Today())"}>}DISTINCT Product)

You count the distinct product with following conditions (Explicited by set analysis)

(A) AddMonths(Today(),-6) is a date starting 6 months before today

the whole condition ">=$(=AddMonths(Today(),-6))<=$(=Today())" says that the field Date must be

>=(A) and <= today

and finally you have to know that if you write (=Expression) the expression is evaluated so in your case

$(=AddMonths(Today(),-6))

computes the function Addmonths

Hope this helps

hcabrera — Fri, 26 Feb 2016 13:25:32 GMT

Hi,

This expression does is count the different products dated from 6 months ago ">=$(=AddMonths(Today(),-6) to less equal to today <=$(=Today())"