topic AW:get a diagram from a .csv file in QlikView https://community.qlik.com/t5/QlikView/get-a-diagram-from-a-csv-file/m-p/300226#M1198573 <HTML><HEAD></HEAD><BODY><P>Hello spartakuskus,</P><P>I assume your native language is german. Then it is likely that you have set:</P><P>ThousandSep='.';<BR />DecimalSep=',';</P><P>In consequence all(!) values for Zeit and Wert are loaded as string (text), not as numeric. So try to load the two fields with numeric values where ever possible. I defined new separators before loading from the csv-file:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">SET ThousandSep=''; // leave it blank for the moment<BR />SET DecimalSep='.';<BR />Load ...</PRE></BLOCKQUOTE><BR /><BR /> <P>The rest should be easy as most of your values in the two fields will be recognized as numeric (and therefor are visible in a linechart).</P><P>Regards, Roland</P></BODY></HTML> Mon, 17 Jan 2011 16:13:30 GMT 2011-01-17T16:13:30Z get a diagram from a .csv file https://community.qlik.com/t5/QlikView/get-a-diagram-from-a-csv-file/m-p/300225#M1198572 <HTML><HEAD></HEAD><BODY><P>Hello, I am new to Qlikview and I imported a csv file that has a structure as follows:</P><P>Zeit|Signal [Einheit]|Wert<BR />0.00025|FZ_Gierrate [°/s]|0.24414063<BR />0.00075|DR_a_x <G>|0.04800000<BR />0.00075|DR_a_y <G>|-0.01600000<BR />0.00075|DR_a_z <G>|0.99200000<BR />0.00175|FZ_a_y_1 <G>|0.00990000<BR />0.00175|GW_Bremse_KL_ID328_3_3|aus<BR />0.00175|GW_Bremse_KL_ID328_3_4|aus<BR />0.00175|GW_ESP_ABS_KL_ID328_4_4|aus<BR />0.00225|ABS_E [---]|regelt nicht<BR />0.00225|Bremse_Pedal_S [---]|nicht betaetigt<BR />0.00225|FZ_Gierrate_1 [°/s]|0.03760000<BR />0.00275|Reifen_p_Warn [---]|druck ok<BR />0.00325|FZ_Gierrate [°/s]|0.07500000<BR />0.00325|FZ_a_y <G>|0.02459867</G></G></G></G></G></P><P>...and so on</P><P>The delimiter is '|' so that I have here 3 columns. First is timestamp, second signalname and third value.</P><P>My question now is, how can I make a line diagram that shows the value course of a certain signal e.g. "FZ_Gierrate [°/s]" over time?</P><P>I tried a lot but didn't made it.</P><P>Hope you may help me. Thanks in advance.</P></BODY></HTML> Mon, 17 Jan 2011 14:08:18 GMT https://community.qlik.com/t5/QlikView/get-a-diagram-from-a-csv-file/m-p/300225#M1198572 2011-01-17T14:08:18Z AW:get a diagram from a .csv file https://community.qlik.com/t5/QlikView/get-a-diagram-from-a-csv-file/m-p/300226#M1198573 <HTML><HEAD></HEAD><BODY><P>Hello spartakuskus,</P><P>I assume your native language is german. Then it is likely that you have set:</P><P>ThousandSep='.';<BR />DecimalSep=',';</P><P>In consequence all(!) values for Zeit and Wert are loaded as string (text), not as numeric. So try to load the two fields with numeric values where ever possible. I defined new separators before loading from the csv-file:</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">SET ThousandSep=''; // leave it blank for the moment<BR />SET DecimalSep='.';<BR />Load ...</PRE></BLOCKQUOTE><BR /><BR /> <P>The rest should be easy as most of your values in the two fields will be recognized as numeric (and therefor are visible in a linechart).</P><P>Regards, Roland</P></BODY></HTML> Mon, 17 Jan 2011 16:13:30 GMT https://community.qlik.com/t5/QlikView/get-a-diagram-from-a-csv-file/m-p/300226#M1198573 2011-01-17T16:13:30Z