topic Re: Bar chart in QlikView

Bar chart

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have created a bar chart (see attached) which shows the budget by month.

I'd like to amend it to show the budget by month for FY2017 and just one bar for the FY2018 ($3965).

Appreciate your assistance.

Thanks

Re: Bar chart

prma7799 — Thu, 29 Jun 2017 05:21:47 GMT

like this ?

Re: Bar chart

prma7799 — Thu, 29 Jun 2017 05:24:10 GMT

Some new changes

Re: Bar chart

passionate — Thu, 29 Jun 2017 05:33:08 GMT

Hi,

Use Dimension limit for first 13 values.

Rename label for others with 2018.

Regards,

Pankaj

Re: Bar chart

antoniotiman — Thu, 29 Jun 2017 05:39:04 GMT

HI,

see Attachment.

Regards,

Antonio.

Re: Bar chart

shamitshah — Thu, 29 Jun 2017 05:54:57 GMT

Hi Pankaj,

Are you able to attach your suggestion?

Thanks

Re: Bar chart

prma7799 — Thu, 29 Jun 2017 05:59:55 GMT

Please check

Re: Bar chart

passionate — Thu, 29 Jun 2017 06:38:03 GMT

I won't be able to attach QVW.

But, steps are easy:

1. Dimension: Month

2. Expression: Sum(Budget)

3.Go to dimension limit tab -> Restrict your data-> First-> 13

4. Keep others check box enabled and put label as 2018.

Regards,

Pankaj

Re: Bar chart

shamitshah — Thu, 29 Jun 2017 07:03:08 GMT

Thanks!

Re: Bar chart

antoniotiman — Thu, 29 Jun 2017 07:27:20 GMT

Hi Shamit,

Thanks.

I made a slight adjustment regarding Label.

Regards,

Antonio