topic Re: Problem that need solution in QlikView

Problem that need solution

Thu, 02 Apr 2015 09:47:48 GMT

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,

Re: Problem that need solution

morganaaron — Thu, 02 Apr 2015 10:01:32 GMT

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?

Re: Problem that need solution

Thu, 02 Apr 2015 10:09:28 GMT

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

Re: Problem that need solution

morganaaron — Thu, 02 Apr 2015 10:19:32 GMT

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?

Re: Problem that need solution

Thu, 02 Apr 2015 10:30:25 GMT

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

Re: Problem that need solution

morganaaron — Thu, 02 Apr 2015 10:32:47 GMT

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

Re: Problem that need solution

Thu, 02 Apr 2015 10:42:20 GMT

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

Re: Problem that need solution

morganaaron — Thu, 02 Apr 2015 11:02:51 GMT

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.

Re: Problem that need solution

Thu, 02 Apr 2015 11:36:56 GMT

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.

Re: Problem that need solution

morganaaron — Thu, 02 Apr 2015 12:02:30 GMT

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!

Re: Problem that need solution

Thu, 02 Apr 2015 13:01:14 GMT

Aaron,

I understand what you are saying. How do I mark it as correct and i will do as you say. I am new to this and do not know the correct way about doing things here. I am now trying to do the same graph that you helped me with for line of business. I changed the expression from product to line of business, but am getting the same again no data to display. Is that that is all that is required, I have looked at everything else in your solution and have it the same for my line of business but it does not seem to work.

Thanks,

Stephen.

Re: Problem that need solution

Thu, 02 Apr 2015 13:09:27 GMT

Aaron,

It is ok, i got it sorted and i understand now what you are saying. I mark you as the correct solution not me. I have just done this

Stephen