topic Charts and % change based on a set date in QlikView

Charts and % change based on a set date

james — Tue, 25 Jan 2011 01:12:03 GMT

I know this may be real easy, but I have spent countless hours trying to get a chart to show a percentage change based on let us say 01/03/2011.

For example, on 1/03/2011 the price was $50.00. Each day the price may go up or down and today the price is $58.00

I cannot seem to get the chart to always look at 1/03/2011 and use that as the base for the division…. Any ideas?

I have tried Above but it doesnt seem to work

Charts and % change based on a set date

pover — Tue, 25 Jan 2011 01:28:14 GMT

Instead of above() you can use top().

Set analysis could also be used to fix the reference date of the price.

Regards.

Charts and % change based on a set date

james — Tue, 25 Jan 2011 18:03:02 GMT

Yeah, im sure it something simple with the expression; as you can see in the attached qvw

Anyone have any ideas, it would be appreciated....

Charts and % change based on a set date

matt_crowther — Tue, 25 Jan 2011 18:22:06 GMT

As per Karl's suggestion.

File Attached.

Hope that helps,

Matt - Visual Analytics Ltd

Charts and % change based on a set date

pover — Tue, 25 Jan 2011 18:23:57 GMT

Here are 2 options.

Regards.

Charts and % change based on a set date

james — Tue, 25 Jan 2011 18:32:20 GMT

Many Thanks... I used Top and it didnt work.... Weird.... Coffee is needed

Charts and % change based on a set date

james — Wed, 26 Jan 2011 00:24:59 GMT

Any tips on how to get the chart to render 2 lines for 2 differecnt sets of data? When I select 1 Selection, it renders correct, the minute I choose 2, it does not work

Charts and % change based on a set date

pover — Wed, 26 Jan 2011 01:33:11 GMT

Use the Set Analysis solution like the attached example.

Regards.

Charts and % change based on a set date

james — Wed, 26 Jan 2011 16:02:22 GMT

Thanks Karl.... never ever noticed the < > option....