topic Re: Using Bar chart in QlikView

Using Bar chart

paulwalker — Tue, 17 Dec 2013 13:50:46 GMT

Hi Community,

I Need Some help...........

I have a one field in that i have one If condition(Executed, Non Executed, Lapsed)

In my BAR chart i want to show different colors in Single bar...

Suppose XYZ this is my field in that i have conditions..........(Executed=Red, Non Executed=Blue and Lapsed=Orange)

Re: Using Bar chart

Anonymous — Tue, 17 Dec 2013 14:08:18 GMT

You probably want to split this into three expressions and then create a stacked bar chart. In each expression use set analysis to target just the data you want e.g.

Sum({Status={'Executed'}>} Measure)

Sum({Status={'Non Executed'}>} Measure)

Sum({Status={'Lapsed'}>} Measure)

Re: Using Bar chart

paulwalker — Tue, 17 Dec 2013 14:11:27 GMT

Hi Adam,

That is my dimension field

suppose XYZ my dimension field

and Sum(sales) Expression

Re: Using Bar chart

Anonymous — Tue, 17 Dec 2013 14:20:30 GMT

Hi Paul,

There are two approaches. Either the set analysis above or using two dimensions. However you decide to split up the Executed/Non Executed/Lapsed you will ultimately get down to creating a stacked bar chart. The set analysis route gives you more control over the colours and the two dimensions route is quicker and easier.

If you can let me know the three field names then I can maybe create some more useful examples for you.

Re: Using Bar chart

paulwalker — Tue, 17 Dec 2013 15:02:47 GMT

Here small Example

xyz

Here 0--->Non Executed

1-----> Executed

-(null)-----> Lapsed

Like a below Image

Re: Using Bar chart

Anonymous — Tue, 17 Dec 2013 15:13:09 GMT

OK, if you only want a single bar in your chart then you can cheat and use a calculated dimension, such as

='xyz'

Then your expressions can be whatever you need to define your three sections, so probably set analysis

Count({<xyz={'0'}>} xyz)

or with an if statement

Sum(If(xyz='0',1,0))