Problem that need solution

[#1]

Hi,

Is there a way I can show the following from the data I have uploaded similar to he customer retention pie chart I have already created.

I am using count(Policy Renewed) as the expression.

Customer Retention per Age Interval

Customer Retention per Customer Gender

Customer Retention per Sales Rep Name

Customer Retention per Customer Martial Status

Customer Retention per Product

Customer Retention per Line of Business

Customer Retention per Product Region

Thanks,

Stephen,

[morganaaron]

Do you want these as stacked dimensions? I.e. you want male yes, male no, female yes, female no...etc. all in one pie? Two dimension pie charts are generally never a good idea. Consider using a stacked bar chart or other type of chart? Or you could create two pies, one for each gender, and therefore use gender as a trellis dimension?

[#3]

I think you are correct. It does not look good. A stacked bar chart would be better. But how can I show both Policy Renewed? information and the product information in a stacked bar chart or is this pointless. Can this be achieved by drilling down. i am only new to Qlikview and am trying to represent the information as best I know. How do you drill down and when do you use this

[morganaaron]

It depends what information you need from this. Do you want to know what % of each Product is a Yes/No/Cancellation? Or are you more interested in the number of 'Yes' replies for each Product in comparison to each other?

You could drilldown, but I don't think there's need looking at your data. You could add two dimensions (1 - Product, 2 - Policy Renewed?) and then how you structure the expression would depend on what you want to show. Your same expression Count([Policy Renewed]) would give you the raw numbers, but an expression like Count(Total <Product> [Policy Renewed?]) would give you the % breakdown of the responses for each product.

As I say, it depends on what information you need. What's the question you want to ask of the data?

[#5]

I actually have what you are saying at the moment, 2 dimension Product and Policy Renewed? and the same expression Count([PR?]). I might try the other expression now. Basically I want to see policy renewal rate per product

[morganaaron]

If you want to see rate. then the second option is what you want to go for.

The exact expression would be: Count([PR?]) / Count(Total <Product> [PR?])

Ensure Product is your 1st Dim, PR? is your 2nd Dim. The expression should then give you the breakdown by PR for each Product. Ensure that in the "Number" tab you select "Show in Percent (%)" at the bottom, you may also have to fix your Axes to a Static Max of 1 (as sometimes it runs upto 120%!).

Aaron

[#7]

Hi Aaron,

I am trying above but it does not seem to work for me, i am getting no data to display for some reason

[morganaaron · Accepted solution]

Can be a bit tricky - here's my version with the stacked bar chart by product. Have a look at the expression and settings and shout if you have any questions.

[#9]

Thanks Aaron.

Thats brilliant. It looks deadly. I have one more question. I have put the CR per Product, CR per Line of Business and CR per region in a container but I want to move this container to another part of my sheet and for some reason I am not able to shift its position.

Regards,

Stephen.

[morganaaron]

Try hold down the alt key and click + drag it - see if that will work.

As an aside, though I appreciate you like your own answer, the "correct" answer will be the one somebody searching for the same issue will want to see - and yours is an answer as such, more a question. Can you mark the solution as the correct answer, and open up another question if you have additional queries? That way it helps the community as best possible.

Also - try to include a reference to the question in the discusssions name. "Problem that need solution" is true, but it doesn't describe the issue and therefore you're unlikely to draw help. Try and name it something like "Can I create a pie chart with two dimensions?" or something similar to your actual question.

Otherwise, happy to help!