topic Re: Use of Only() Function in QlikView

Use of Only() Function

Anonymous — Wed, 15 Apr 2015 10:33:52 GMT

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.

Re: Use of Only() Function

Gysbert_Wassenaar — Wed, 15 Apr 2015 10:41:33 GMT

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

Re: Use of Only() Function

Anonymous — Wed, 15 Apr 2015 10:44:10 GMT

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.

Re: Use of Only() Function

Gysbert_Wassenaar — Wed, 15 Apr 2015 10:49:00 GMT

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.

Re: Use of Only() Function

Anonymous — Wed, 15 Apr 2015 10:54:08 GMT

Thanks alot Gysbert (y)

Re: Use of Only() Function

Anonymous — Wed, 15 Apr 2015 10:55:29 GMT

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