Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to select data with other DB table

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?

1 Reply

Re: How to select data with other DB table

'$=<ID={1}>ResMon'

What do you expect that to do? What's it supposed to mean? The syntax looks so bizarre to me that I have no idea what you're trying to do there.


talk is cheap, supply exceeds demand