topic Re: Little issues in QlikView

Little issues

Thu, 06 Mar 2014 00:18:15 GMT

I'm starting using QV, and don´t know many of the syntax for using it, i hava a graph (Data Table) and whan´t to create a Column with an operation bettwen the result columns Column1/Column2, what's the sintax?

For another column I whanted the latest value of o row of data, not the MAX, or MIN but the "latest in time", is there a function for it? If there is the order or the data influences the result?

On another I whated the minimum value but for records above 0 (>0), what's the sintax?

Re: Little issues

MarcoWedel — Thu, 06 Mar 2014 00:33:54 GMT

Hi Tito,

could you please upload an example of your data table for a better understanding of your question?

thanks

regards

Marco

Re: Little issues

rwunderlich — Thu, 06 Mar 2014 01:07:32 GMT

You can operate on columns in a chart simply by using the column labels in the expression.

TotalSales - COGS

You may also use the column(n) function to reference expression columns, but this is not advised if a label is available.

To get the "latest" value from a row, look at the FirstSortedValue() function in Help or the Ref Guide.

There are probably a few ways to get the min above zero. Here are a couple. Assume "Expression1" is the name of your field.

=min(if(Expression1>0, Expression1))

=min({<Expression1={">0"}>}Expression1)

-Rob