topic Re: Hide some legends in Bar Chart based on set analysis in QlikView

Hide some legends in Bar Chart based on set analysis

Anonymous — Fri, 08 Jun 2018 11:46:49 GMT

I’m trying to get a bar chart legend to only show the legend if there is a valid entry for that month.

There are five expressions like this: =Sum({<Month>}CostsP5)/Sum({<Month>}Costs)

And the Label for each is like:

=NameP5

I’ve tried changing the label to: =If(Len(NameP5)>0,NameP5,'')

Any ideas?

Re: Hide some legends in Bar Chart based on set analysis

sunny_talwar — Fri, 08 Jun 2018 11:49:17 GMT

But we do see Grey and other colors in the chart, shouldn't the legend show this info? May be try this

=Only({<Month>} NameP5)

Re: Hide some legends in Bar Chart based on set analysis

Anonymous — Fri, 08 Jun 2018 12:02:27 GMT

They are, but the projects can change over the year so that Project 2 in February will be different from Project 2 in November. I only want to show the legend for projects running in the current month, but leave the chart showing all projects.

Re: Hide some legends in Bar Chart based on set analysis

sunny_talwar — Fri, 08 Jun 2018 12:04:20 GMT

I think this might be challenging to do it this way... can you may be do this with 2 dimensions and 1 expression, instead of 1 dimension and 5 expressions?

Re: Hide some legends in Bar Chart based on set analysis

Anonymous — Fri, 08 Jun 2018 12:16:19 GMT

The data looks something like this:

MonthYear	Programme 1	Programme 2	Programme 3	Programme 4	Programme 5	Costs Programme 1	Costs Programme 2	Costs Programme 3	Costs Programme 4	Costs Programme 5
Jan-18	AJH	SR	NCP	RPN	Oct	100	50	20	10	10
Feb-18	AJH	SR	NCP	RPN	Oct	80	20	70	20	20
Mar-18	Project 1	AJH	BBJ			60	20	10
Apr-18	Project 1	AJH				120	30
May-18	Project 1					150
Jun-18
Jul-18

Re: Hide some legends in Bar Chart based on set analysis

sunny_talwar — Fri, 08 Jun 2018 12:22:12 GMT

And do you use CrossTable load to transform your data?

Re: Hide some legends in Bar Chart based on set analysis

Anonymous — Fri, 08 Jun 2018 14:23:05 GMT

We don't. There's a lot more on each line, although a lot of them are also broken down by Programme.