Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Double Qoutes inside another Double Qoutes in expression

below expression is giving error because I am using Double Qoutes inside another Double Qoutes in expression.

Please let me know if there is a another way to write the same syntax.

concat(distinct

{

<dim1={"=count({<dim2={">10"},order_date={'$(=max(order_date))'}>}dim1)>=1"}

-

{"=count({<dim2={">10"},order_date={'$(=min(order_date))'}>}dim1)>=1"}>

}

dim1,Chr(10))

1 Reply

Re: Double Qoutes inside another Double Qoutes in expression

Try this:

Concat(distinct

{

<dim1={"=count({<dim2={'>10'},order_date={'$(=max(order_date))'}>}dim1)>=1"}

-

{"=count({<dim2={'>10'},order_date={'$(=min(order_date))'}>}dim1)>=1"}>

}

dim1,Chr(10))