Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
morenoju
Contributor III

Set analysis where field = another field

Hi guys,

I have a line chart with the following expression:

avg({<link_date={'1/5/2019'}>}speed)

Now I want that date to be picked by the user from a filter pane. I have another calendar that uses the field link_date_A, so I thought I'd be able to do:

avg({<link_date=link_date_A>}speed)

However, that does not draw any line.

Do you know if this is a syntax problem? I've tried different things without success.

Thanks

1 Solution

Accepted Solutions

Re: Set analysis where field = another field

May be this

avg({<link_date = p(link_date_A)>}speed)
5 Replies
dilipranjith
Honored Contributor

Re: Set analysis where field = another field

I am assuming the 2 dates are in different tables.
if so try something like this

avg({<KeyIDColumn={"=link_date=link_date_A"}>}speed)
morenoju
Contributor III

Re: Set analysis where field = another field

Thanks for your response. However, the line is being drawn without me selecting anything from the link_date_A filter pane. And when I do select different dates, the line is not changing. That makes me think it's not doing the job.
Do you have any other idea?
Thanks!

Re: Set analysis where field = another field

May be this

avg({<link_date = p(link_date_A)>}speed)
dilipranjith
Honored Contributor

Re: Set analysis where field = another field

You mean the date link_date_A is being picked by a filter?
if so try 2 options
1- create a variable which will format picks appropriately and use it in your set analysis.
2 - p(link_date_A) method
morenoju
Contributor III

Re: Set analysis where field = another field

Thank you, guys. I'm going to use the p(link_date_A) .