topic Re: Line Chart with dynamic selection displaying two series in QlikView

Line Chart with dynamic selection displaying two series

Wed, 12 Feb 2014 08:31:58 GMT

Hello fellows,

I have a data table with the attributes (date, X, Y):

Date, X, Y

8-Feb-14 1 0.4343

8-Feb-14 2 0.4311

8-Feb-14 3 4343

8-Feb-14 4 65

8-Feb-14 5 67.5

7-Feb-14 1 0.555

7-Feb-14 2 0.656

7-Feb-14 3 111

7-Feb-14 4 22

7-Feb-14 5 657.5

The user can select a date.

Now I'm trying to build a line chart displaying two series of (x,y) values, one for selected date and one for previous date. While building first series was quite obvious, creating an expression for second one is not straightforward.

The (potential) algorithm is to:

- get selected date

- calculate previous date (if not available, try one before)

- get (x,y) values for previous date

Any suggestions, please?

Re: Line Chart with dynamic selection displaying two series

luis_pimentel — Wed, 12 Feb 2014 08:45:50 GMT

For your second expression, try something like:

sum({< [Date]= {"$(=date(max([Date])-1))"}>} )

Re: Line Chart with dynamic selection displaying two series

Wed, 12 Feb 2014 09:14:18 GMT

Luis,

What if I don't need 'sum' of values, but rather values themselves?

Re: Line Chart with dynamic selection displaying two series

luis_pimentel — Wed, 12 Feb 2014 09:16:18 GMT

could you share a snapshot of your actual line chart, with the current selection date expression?

Re: Line Chart with dynamic selection displaying two series

Wed, 12 Feb 2014 09:27:07 GMT

Chart displaying (x,y) (interest rate, maturity) data:

Expression I'm trying to build: