topic Is it possible to run various charts off different sql queries in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-run-various-charts-off-different-sql-queries/m-p/278553#M1179157 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have connected my Qlikview document via ODBC to a view in SQL which has most of the fields I will need.</P><P>My challenge is that some of the columns that I will need to be displayed in QV where calculated on the fly in SQL.</P><P>How do I display these same fields in QlikView?&nbsp; Do I write calculated fields and if so, how?&nbsp; I am told calculated fields in QlikView slow the system down?</P><P></P><P>The other approach I was considering, is to write out the actual queries that run the calculation in QV, (the sql editor area).&nbsp; Is it possible to display charts that run off certain parts of a query i.e. can I have about 7 sql queries written in qlikview that feed 7 different charts?&nbsp; If it is possible, how do I specify that a query is linked to a particular chart?</P><P></P><P>Any suggestions would be welcome.</P><P></P><P>Thanking you in advance.</P><P></P><P>Natasha </P></BODY></HTML> Mon, 16 Jan 2012 10:54:21 GMT 2012-01-16T10:54:21Z Is it possible to run various charts off different sql queries https://community.qlik.com/t5/QlikView/Is-it-possible-to-run-various-charts-off-different-sql-queries/m-p/278553#M1179157 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have connected my Qlikview document via ODBC to a view in SQL which has most of the fields I will need.</P><P>My challenge is that some of the columns that I will need to be displayed in QV where calculated on the fly in SQL.</P><P>How do I display these same fields in QlikView?&nbsp; Do I write calculated fields and if so, how?&nbsp; I am told calculated fields in QlikView slow the system down?</P><P></P><P>The other approach I was considering, is to write out the actual queries that run the calculation in QV, (the sql editor area).&nbsp; Is it possible to display charts that run off certain parts of a query i.e. can I have about 7 sql queries written in qlikview that feed 7 different charts?&nbsp; If it is possible, how do I specify that a query is linked to a particular chart?</P><P></P><P>Any suggestions would be welcome.</P><P></P><P>Thanking you in advance.</P><P></P><P>Natasha </P></BODY></HTML> Mon, 16 Jan 2012 10:54:21 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-run-various-charts-off-different-sql-queries/m-p/278553#M1179157 2012-01-16T10:54:21Z