topic Trouble Charting Expressions in QlikView https://community.qlik.com/t5/QlikView/Trouble-Charting-Expressions/m-p/1143678#M914605 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having issues expressions and creating a line chart from my data.</P><P>I have</P><P>[Date]&nbsp;&nbsp;&nbsp;&nbsp; [CurrencyType]&nbsp;&nbsp;&nbsp;&nbsp; [Country]&nbsp;&nbsp;&nbsp;&nbsp; [Units Per USD]&nbsp;&nbsp; [USD Per Unit&nbsp; Month]&nbsp;&nbsp;&nbsp;&nbsp; [Year]&nbsp;&nbsp;&nbsp;&nbsp; [Month]</P><P></P><P></P><P>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.<BR />For example I want to display the last 30 days worth of data from a particular country. Lets say CurrencyType = 'AUD'<BR />My dimension is the date of course but it just isn't working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>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]<BR />Ive managed to do this before but my data was in a different format than this one.</P><P></P><P>Any help would be appreciated </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Trouble Charting Expressions https://community.qlik.com/t5/QlikView/Trouble-Charting-Expressions/m-p/1143678#M914605 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am having issues expressions and creating a line chart from my data.</P><P>I have</P><P>[Date]&nbsp;&nbsp;&nbsp;&nbsp; [CurrencyType]&nbsp;&nbsp;&nbsp;&nbsp; [Country]&nbsp;&nbsp;&nbsp;&nbsp; [Units Per USD]&nbsp;&nbsp; [USD Per Unit&nbsp; Month]&nbsp;&nbsp;&nbsp;&nbsp; [Year]&nbsp;&nbsp;&nbsp;&nbsp; [Month]</P><P></P><P></P><P>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.<BR />For example I want to display the last 30 days worth of data from a particular country. Lets say CurrencyType = 'AUD'<BR />My dimension is the date of course but it just isn't working <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P><P></P><P>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]<BR />Ive managed to do this before but my data was in a different format than this one.</P><P></P><P>Any help would be appreciated </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Trouble-Charting-Expressions/m-p/1143678#M914605 2020-11-25T16:16:04Z Re: Trouble Charting Expressions https://community.qlik.com/t5/QlikView/Trouble-Charting-Expressions/m-p/1143679#M914606 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please read these two documents:</P><UL><LI><A _jive_internal="true" data-containerid="2001" data-containertype="14" data-objectid="2380" data-objecttype="102" href="https://community.qlik.com/docs/DOC-2380" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">QlikCommunity Tip: How to get answers to your post?</A></LI><LI><A _jive_internal="true" data-containerid="2049" data-containertype="14" data-objectid="1290" data-objecttype="102" href="https://community.qlik.com/docs/DOC-1290" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7;">Preparing examples for Upload - Reduction and Data Scrambling</A></LI></UL></BODY></HTML> Wed, 25 May 2016 15:41:04 GMT https://community.qlik.com/t5/QlikView/Trouble-Charting-Expressions/m-p/1143679#M914606 Gysbert_Wassenaar 2016-05-25T15:41:04Z