Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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