topic Controlling Dimension Values in QlikView

Controlling Dimension Values

mustafaelryah — Tue, 27 Jan 2015 12:44:11 GMT

Dear All,

How can I choose only some values (string values) from my dimension (suppose its dimension_type) of chart.

Looking forward.

jonathandienst — Tue, 27 Jan 2015 12:48:50 GMT

Select from a list box to allow the user to control the selection
Use a calculated dimension to filter the values (with suppress nulls for the dimension) - like this:

=Aggr(If(dimension_type <> 'None', dimension_type), dimension_type)

Use set analysis in the expression(s) to filter the values (with suppress nulls/suppress zero values for the expressions) like:

=Sum({<dimension_type -= {'None'}>} ....)

HTH

Jonathan

mustafaelryah — Tue, 27 Jan 2015 13:34:07 GMT

Hi,

Thanks a lot, I used a calculated dimension and I typed this expression

=Sum({<Account_Type ={'operational_expenses'}>}Account_Type)

and syntax is correct in the editor , but when I browsed the chart ,

show me (Error in calculation dimension =Sum({<Account_Type ={'operational_expenses'}>}Account_Type)) message

can you help me please!

MarcoWedel — Tue, 27 Jan 2015 13:41:10 GMT

- you want to sum a field, that holds text values (Sum Account_Type where Account_Type = 'operational_expenses') or are those dual values?

- When using Aggregations in calculated dimensions, you have to do so using the aggr() function like

=Aggr(Sum({<Account_Type ={'operational_expenses'}>} some_numerical_field), field_to_aggregate_over)

hope this helps

regards

Marco