topic Re: Help for needed chart in QlikView

Help for needed chart

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I need to create a stacked bar chart with customer name as the dimension. I want to show the number of open defects per customer based on the severity level. I know this is set analysis, but I'm not sure how to do this with 3 variables:

Defect type = Defect

Severity = 0 or 1 or 2 or 3

Status = OPEN

Here is the excel version:

All help and guidance is much appreciated!

Re: Help for needed chart

vishsaggi — Mon, 02 Oct 2017 15:56:00 GMT

Can you share some sample data to work on?

Re: Help for needed chart

sudeepkm — Mon, 02 Oct 2017 16:31:23 GMT

you can create a bar chart and then

Select [Customer Name] as first dimension and Severity as Second

Then add expression: count({< Status={'Open'}, [Defect type] = {'Defect'}>}defect_id)

Select your bar chart style as Stacked.

I've assumed the field names but you can use your actual field names in your app.

Re: Help for needed chart

Mon, 02 Oct 2017 16:47:43 GMT

Sorry, disregard the previous dataset.....

Re: Help for needed chart

sudeepkm — Mon, 02 Oct 2017 16:55:12 GMT

here is one way you can create your chart. PFA.

Re: Help for needed chart

Mon, 02 Oct 2017 17:48:58 GMT

I have the chart created, however, can you tell me how to show the defect counts as ascending? The only way I can see to sort is by company or severity.

Re: Help for needed chart

vishsaggi — Mon, 02 Oct 2017 17:54:18 GMT

Use this count expression in your Sort tab sort by Expression Check box then write this Count expr and change it to ascending.

Re: Help for needed chart

Mon, 02 Oct 2017 17:57:03 GMT

Of course...thank you!

Thanks to all for the excellent help...problem solved!