topic Re: expression in QlikView

expression

samuel_brierley — Thu, 29 Aug 2013 08:26:27 GMT

Hi, Im new to qlikview and not quite sure how to writte expressions that are relativly obvious in excel

what im after is replicating what is in collumn E which is basically at the time of collumn A how many assets where out.

not sure if this will make a difference to the expression but their are multiple spreadsheets, one for each month.

thanks

Re: expression

vikasmahajan — Thu, 29 Aug 2013 11:07:12 GMT

Which is your data source whether it is excel or sql backend ?

Re: expression

samuel_brierley — Thu, 29 Aug 2013 11:11:53 GMT

Excel

Re: expression

vikasmahajan — Thu, 29 Aug 2013 11:27:16 GMT

Load excel in Qlikivew.

Give Following Expressions

Label:

=date(max(Date),'MMM-YY')

Expression:

SUM({$<FinancialYear=,MonthName=,FiscalYear = {$(=max(FiscalYear))},MonthNumber = {"<=$(=max({<FiscalYear={$(=max(FiscalYear))}>} MonthNumber))>$(=max({<FiscalYear={$(=max(FiscalYear))}>} MonthNumber)-1)"}>}Assets Broke)

Same expressions for Assets Fixed and Assets Out .

Hope this help you.

Vikas

Re: expression

ToniKautto — Thu, 29 Aug 2013 11:38:21 GMT

The answer to your question depends on what your data model in QlikView looks like. In the attached example I have loaded your excel sheet as the source, excluding the column E. There is also an additional field to make all loaded rows unique, just to replicate the view in Excel, since your data has a few identical rows.

In the QlikView chart object you first define which dimensions to calculate the object over. Writing the expression over which the result is calculated is based on the field names or by using aggregation functions. The complexity of these is a result of the data model and what you want to aggregate.

To get a quick start please browse through the free online training;

QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | QlikView

For more knowledge there is also classroom training available;

http://www.qlik.com/us/services/training