topic How to use selected elements from a bar-chart in another bar-chart in QlikView

How to use selected elements from a bar-chart in another bar-chart

Anonymous — Wed, 11 Mar 2015 15:52:29 GMT

Hi,

I have the following problem:

I select e.g. the “dates of sale” (2014-01-20 & 2014-01-23) in the bar-chart_1 (sales=20.000 & 25.000). In the second bar-chart (in the same alternate state) I shall be able to find out and to show whole “dates of sale” of the past two years that contain “sales data” roughly figures like sales-data in the bar-chart_1 (with sales 20.000 & 25.000).

I’m wondering if that ever possible by Qlikview functions like set analysis?

Thank you for any help.

Re: How to use selected elements from a bar-chart in another bar-chart

Roop — Wed, 11 Mar 2015 16:34:50 GMT

I don't think that you will need alternate states - You should be bale to do this using the selections made. I have attached an example for you to review

Hope this helps

Rupert

Re: How to use selected elements from a bar-chart in another bar-chart

Anonymous — Wed, 11 Mar 2015 21:07:47 GMT

Thank you Rupert,

I meant whether is that possible to find a value (pattern) from a chart in another one (in the past) like that:

chart_1: date = 1/1/15, value = 5000

chart_2: e.g. statement = sum( {$<~date < {“selected_Date_in_Chart”}>} sales)

result: date = 5/4/14, value = 4900

date = 28/10/13, value = 5100

Is such pattern possible?

Thank you again.

Re: How to use selected elements from a bar-chart in another bar-chart

Anonymous — Thu, 12 Mar 2015 14:13:40 GMT

Rupert,

I solved my quesion by this statement with set:

=sum( {$<DATE={" <$(=$(vDATE) )" }, SALES={"<$(= $(vSALES) )" }>} SALES)

Whereas vDATE = getfieldselections(DATE) and vSALES=getfieldselections(SALES) are the needed variables.

Best regards