topic Re: Expression Correction in QlikView

Expression Correction

Wed, 21 Mar 2012 15:41:02 GMT

Hi,

I am trying find the count of customers who shipped 2 months prior to their due date and here is the expression am using but it just shows blank.please let me know if I am doing something wrong in the expression.

=count({<Date(Shipping_Date,'YYYYMM') = {">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}
distinct Customer_Key)

Thanks,

Swetha

Expression Correction

Wed, 21 Mar 2012 15:49:58 GMT

I do not think you can use an expression in the first section of set analysis.

Try doing

Date(Shipping_Date,'YYYYMM')

in the script as a new field, then using the new field there instead

Expression Correction

Wed, 21 Mar 2012 19:06:24 GMT

Thank You for the reply.

I did replace the first part of the expression with a filed but still does not give the reult.I thibnk something is wrong with

{">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}

because when I replace the above value with some year and number the expression gives the result.

Thanks,

Swetha

Re: Expression Correction

Wed, 21 Mar 2012 19:06:38 GMT

Thank You for the reply.

I did replace the first part of the expression with a filed but still does not give the reult.I thibnk something is wrong with

{">=$(=Date(AddMonths(Customer_Due_Date1,-2),'YYYYMM') <=$(=Date(Customer_Due_Date1,'YYYYMM'))"}>}

because when I replace the above value with some year and number the expression gives the result.

Thanks,

Swetha