topic Re: 2 requirements in a Single Chart in QlikView

2 requirements in a Single Chart

dmohanty — Thu, 04 Sep 2014 12:25:03 GMT

Hi All,

I have a requirement like this, where I have 2 dimensions: SBU, Quarter and a Measure: Revenue

In a Bar chart I am showing the Total Revenue for different SBU by Quarters (where SBU is 1st dimension and Quarter is 2nd). THAT I AM ABLE TO DO LIKE BELOW SHOWN

Now on the same chart, I also have to show the total Revenue for different SBU only (now not Quarter wise)

Can someone please help in showing one example/ideas?

Regards!!!

Re: 2 requirements in a Single Chart

MK_QSL — Thu, 04 Sep 2014 13:08:27 GMT

Add below in your script....

Considering your Fact Table is Temp:

Temp:

Load SBU, Quarter, Revenue From TableName;

Join

Load SBU, SUM(Revenue) as Revenue Resident Temp

Group By SBU;

Now Create a Bar Chart

Dimension

SBU

Quarter

Expression

SUM(Revenue)

Re: 2 requirements in a Single Chart

dmohanty — Thu, 04 Sep 2014 16:34:39 GMT

Hi Manish,

Thank you for the response.

But I wanted a different chart/look which would show only SBU and Revenue. Some Button or Cyclic group kind of thing will help.

Can you help some?

Re: 2 requirements in a Single Chart

Anonymous — Thu, 04 Sep 2014 16:39:02 GMT

Yup, a Drill Down or Cyclic group could be what you are after, so give it a go.

On the Dimension tab of your Bar Chart Properties click <Edit Groups>

Re: 2 requirements in a Single Chart

dmohanty — Thu, 04 Sep 2014 17:27:25 GMT

HI Bill,

Can you please help on this?

One chart would show SBU and Quarter
Other chart should show ONLY SBU.

But both should be in a single place (Switching by Button/Cyclic group etc)

Re: 2 requirements in a Single Chart

Anonymous — Thu, 04 Sep 2014 17:34:14 GMT

Aaahhh !! I understand what you are after now.

Create Chart with both Dimensions
For the Quarter tick <Enable Condition> and check whether a variable say vShowQuarter is 1
Create a button with suitable actions to toggle the vShowQuarter variable between 0 and 1

You test first by changing the variable in an Input Box and add the button after that test.

Re: 2 requirements in a Single Chart

dmohanty — Thu, 04 Sep 2014 17:53:52 GMT

Hi Bill,

Its getting more clear to me now. But could you please help a bit, by showing a small example.

It would be really helpful!

Re: 2 requirements in a Single Chart

Anonymous — Thu, 04 Sep 2014 18:00:43 GMT

Have a look at this blog post

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

Re: 2 requirements in a Single Chart

dmohanty — Fri, 05 Sep 2014 05:21:49 GMT

Hi Bill,

This is an excellent learning.

Thanks for helping me out and showing this article. Kudos!