topic Re: Grouped dimension fields in QlikView

Grouped dimension fields

Sun, 22 Mar 2015 20:03:26 GMT

Hi everyone,

Since I'm just starting with QlikView, I don't know how to build a Pie Chart based on the following data:

The pie chart should show the distribution in % of the number of different CustomerID eating Apples, Oranges or Bananas.

I tried already with different methods and functions like aggr, dimension grouping (Cyclic) without any successful result.

Thank you for your help!

Re: Grouped dimension fields

anbu1984 — Mon, 23 Mar 2015 04:57:21 GMT

Expr:

1. Count({<Apples={'yes'}>}Apples)/Count(distinct CustomerId)

2. Count({<Bananas={'yes'}>}Bananas)/Count(distinct CustomerId)

3. Count({<Oranges={'yes'}>}Oranges)/Count(distinct CustomerId)

Re: Grouped dimension fields

sagarkharpude — Mon, 23 Mar 2015 05:27:49 GMT

Please check the attached app.

Re: Grouped dimension fields

Mon, 23 Mar 2015 08:50:42 GMT

Thank you anbu and sagar for the useful information! It worked!

I still have two questions:

1. I tried to select one of the expressions direct from the chart, but it didn't nothing and is not interactive like other charts.

2. Since I'm using QlikSense as well, I tried to add the chart there but I was able to add one dimension only.Do you know how this can be developed in QlikSense?

Thank you in advance!

Regards,