Use of Only() Function

[Anonymous]

hi , i need help with the following dataset

Year		Monthly Expense	Expense
2015		Car Fuel	5000
2015		Electricity bill	4500
2015		A Expense	7000
2015		Other Expenditure	4000
2015		Sudden Expenditure	3000
2015		Bike Oil Treatment	600
2015		Cig Expense	500
2015		Clothing Expense	3000
2015		Car Maintainance	4000
2015		Outting Expense	3000

in Chart Properties i only want to put add calculated dimension in =only({1}{<[Monthly Expense]={'Car Fuel'}>}[Monthly Expense])

and in expression =sum(Expense)

attached is the screenshot with an error.

looking forward to hear from you soon.

[Gysbert_Wassenaar]

Don't use a calculated dimension. Use Monthly Expense as dimension and sum({<[Monthly Expense]={'Car Fuel'}>}Expense) as expression.

[Anonymous]

Basically Gysbert I am new to Qlikview for learning point of view i want to explore when shall we can use calculated dimension thats why i use it there.

[Gysbert_Wassenaar · Accepted solution]

Fine, add an aggr around your calculated dimension expression:

=aggr(only({1}{<[Monthly Expense]={'Car Fuel'}>}[Monthly Expense]),[Monthly Expense])

And don't use calculated dimensions unless you must. Creating a new field in the script is a far better solution, if possible. Using set analysis expressions is generally also a better solution, if possible.

[Anonymous]

Thanks alot Gysbert (y)

[Anonymous]

It works , thanks. and thanks for prompt replies. I m very pleased.