Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

'$=<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