expression

[samuel_brierley]

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

[vikasmahajan]

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

[samuel_brierley]

Excel

[vikasmahajan]

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

[ToniKautto]

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