1 Reply Latest reply: Dec 5, 2016 7:05 AM by Gysbert Wassenaar RSS

    How to select data with other DB table

    Alexandr Bekher

      Hi All,

       

      i need to select months with field from other DB.

       

      With expression

       

      count(distinct

      {$<

      Year={2016} ,[Date-Sales_Date.autoCalendar.Month]={'$=<ID={1}>ResMon'}, [Target]={"Ppl"}

      >}

      [Client])

       

      where <ID={1}>ResMon is other DB criteria.

       

      Qlik Sense return ad hoc element error.

       

      How to solve problem?