topic Re: Analyzing the same data using two bar charts in QlikView

Analyzing the same data using two bar charts

Anonymous — Tue, 27 Oct 2015 10:07:03 GMT

I have a Chart which displays the sale of a particular brand.

Like this (Fig 1)

Since, BMW can have competitors. I need to show that as another chart (instead of everything in a single bar chart)

Like this

So, this is how my dashboard works.

1. User clicks a brand in a List box provided.

2. Fig 1 shows the sales for that Brand.

3. Fig 2 shows the sales of it's competitors

Fig 1 requires a normal SUM(Sales) expression. However, Fig 2 requires values other than the one used in Fig 1.

I tried this using Set Analysis like SUM({<Brand={*}-{'BMW'}>}Sales)

This works only for BMW. I need to calculate the value dynamically based on the selection user makes. GetSelections functions are not working inside set. How this can be done?

Re: Analyzing the same data using two bar charts

miguelbraga — Tue, 27 Oct 2015 10:17:16 GMT

Hi,

You must chek "Always One Value Selected" in your ListBox for your selections. This ListBox should be your field "Brand" and then use set Analysis like this:

=sum({$<Brand <> {GetFieldSelections(Brand)} >} Sales)

Hope it helped

Re: Analyzing the same data using two bar charts

sasikanth — Tue, 27 Oct 2015 10:17:20 GMT

HI,

Comparative analysis will help here

take one Flag competitor then split the Brand Filter in to 2 listboxes

use Set analysis with Alternate states if you want to see Company vs Competitors

Re: Analyzing the same data using two bar charts

jagan — Tue, 27 Oct 2015 10:22:20 GMT

Hi,

Try like this

Chart 1: for BMW

=Sum(Sales)

Chart 2 for Competitors:

=Sum({<Brand={'*'}>} Sales) - Sum(Sales)

Hope this helps you.

Regards,

Jagan.

Re: Analyzing the same data using two bar charts

arasantorule — Tue, 27 Oct 2015 10:24:14 GMT

Hi,

Please use the exclude function in the second chart to exclude the current selection.

SUM({<Brand=E({$}Brand)>}Sales).

Hope this will resolve the issue.

Thanks.

Re: Analyzing the same data using two bar charts

jagan — Tue, 27 Oct 2015 10:24:35 GMT

Please find attached file for solution.

Regards,

jagan.

Re: Analyzing the same data using two bar charts

Anonymous — Tue, 27 Oct 2015 10:26:53 GMT

Thanks Jagan for that quick and brilliant solution. Simply ingenious. Thanks.

Re: Analyzing the same data using two bar charts

swuehl — Tue, 27 Oct 2015 10:28:17 GMT

For the second chart, you can use the e() function, to show the excluded brands:

SUM({<Brand= e() >}Sales)

Re: Analyzing the same data using two bar charts

Anonymous — Tue, 27 Oct 2015 10:30:59 GMT

Another great solution. Thanks