topic Re: Used variable and dimension exclude each other in QlikView

Used variable and dimension exclude each other

nigel987 — Thu, 24 Sep 2015 12:07:16 GMT

Hi,

I have following issue and would appreciate any advice.

My data model is quite complex so I tried to translate it to a more simple scenario.

I have several cars (field 'car') in my database.

Each car can (but does not need to) have special products (field 'product').

These products can be categorized; so each product is either a "main_feature" or an "additional_feature" (field 'product_type', values = main feature or additional feature).

I want to calculate and display the following variable (the average money I make with additional feature for every sold main feature):

Sum({$<product_type={'additional_feature'}>} Price)/Count({$<product_type={'main_feature'}>} feature_ID)

This is working fine, but I want to display the result for each additional_feature. When I select the dimension 'product', it just shows the total value.

Is this clear? Does anyone know how I would need to modify my variable?

Thanks and KR

Re: Used variable and dimension exclude each other

nigel987 — Tue, 29 Sep 2015 09:44:14 GMT

Hi, does nobody have an idea?

Thanks!

Re: Used variable and dimension exclude each other

simenkg — Tue, 29 Sep 2015 09:46:22 GMT

Try:

Sum({$<product_type={'additional_feature'}>} Price)/Count({$<product =,product_type={'main_feature'}>} feature_ID)

Re: Used variable and dimension exclude each other

jonathandienst — Tue, 29 Sep 2015 09:52:20 GMT

Your requirement is not really clear. I suggest that you post a sample qvw containing representative data and your expected results.

Re: Used variable and dimension exclude each other

marcus_sommer — Tue, 29 Sep 2015 09:52:23 GMT

You need to make your expressions independent from any or certain selections. This could be done with adjusted identifier and qualifier like:

Sum(1 {$<product_type={'additional_feature'}>} TOTAL Price)

A good explanation will you find here: Set Analysis: syntaxes, examples

- Marcus