topic Charting using expression in QlikView

Charting using expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

i'm having an issue even getting my data to chart properly, it is all formatted properly and here is a snapshot of the data i am charting

am planning on charting the currency unit of my choice, for example AUD compared to USD per unit by date for the last 1 month much like this http://www.xe.com/currencycharts/?from=AUD&to=USD&view=1M

I have the date as my dimension but cannot seem to get the expression right. Is anyone able to help
On the left on the graph it shows the amount of USD per 1 AUD which is exactly what I want to graph, and this updates each day only showing the previous month (30 days)

Re: Charting using expression

swuehl — Sun, 29 May 2016 00:01:31 GMT

I haven't really understood your last sentence, are you talking about your current chart or the one on the external web site?

If you made a selection in CurrencyUnit field, e.g. AUD, and then create a chart with dimension Date and as expression e.g.

=Avg([USD per Unit])

what do you see?

Re: Charting using expression

Sun, 29 May 2016 16:25:25 GMT

Hi,
Thank you for replying i have done that and it has come up with this line chart

My data sample is very large and contains a large amount of time and countries.
I want the chart to depict one country for example AUD and display the data for that country for the most recent 30 data points.
How am i able to cut down the data being displayed?

Re: Charting using expression

Sun, 29 May 2016 16:30:51 GMT

Whoops i forgot to mention that i dont want to click an option out of the list of countries to display the data from that country

Re: Charting using expression

swuehl — Sun, 29 May 2016 19:28:57 GMT

Try an expression like

=Avg({<CurrencyUnit = {'AUD'}, Date = {">=$(=Date(Max({1} Date)-30,'M/D/YYYY'))"}>} [USD per Unit])