Trouble Charting Expressions

[#1]

Hi,

I am having issues expressions and creating a line chart from my data.

I have

[Date]     [CurrencyType]     [Country]     [Units Per USD]   [USD Per Unit  Month]     [Year]     [Month]

I have QVDs for entire years of data from each country saved in each. I cant seem to display it in a chart at the moment. I think i'm close but missing something.
For example I want to display the last 30 days worth of data from a particular country. Lets say CurrencyType = 'AUD'
My dimension is the date of course but it just isn't working

Ideally i would like an updating chart that displays the previous 30 days of data that will update each day as ever day i would have new data coming in to my QVD. For example one expression for AUD, one expression for HKD, one for JNY for [Units per USD]
Ive managed to do this before but my data was in a different format than this one.

Any help would be appreciated

[Gysbert_Wassenaar]

Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling