topic Re: Combine Dimensions in a Bar Chart in QlikView

Combine Dimensions in a Bar Chart

jmonroe918 — Thu, 16 Nov 2017 04:27:07 GMT

I have a bar chart that has a Dimension of Brochures.Class. The data contains either Class III, Class II, Class I and OTC Drug.

Currently the chart lists each Dimension and sums the number of Total to Review and Total Completed in a stacked bar chart.

How can I combine the Class III and Class II bars into a single bar summing up both (Call it Class II/III). And do the same for Class I and OTC Drug (Call it Class I/Other). So I basically end up with a two-bar chart showing the sum of two expressions.

QVD is attached.

Thanks

Jeff

Re: Combine Dimensions in a Bar Chart

arvind_patil — Thu, 16 Nov 2017 04:33:36 GMT

Hi Jeff,

Please add below code in dimension as calculated dimesion:

=If(Wildmatch(Brochures.Class,'Class 2','Class 3'),'Class II/III',

If(Wildmatch(Brochures.Class,'Class 1','OTC Drug'),'Class I/Other'))

Thanks,

Arvind Patil

Re: Combine Dimensions in a Bar Chart

arvind_patil — Thu, 16 Nov 2017 04:35:34 GMT

Please find the attachment.

Thanks,

Arvind Patil

Re: Combine Dimensions in a Bar Chart

prma7799 — Thu, 16 Nov 2017 04:36:30 GMT

Like this?

Re: Combine Dimensions in a Bar Chart

jmonroe918 — Thu, 16 Nov 2017 05:10:40 GMT

Arvind,that worked perfectly.

Thanks

Jeff

Re: Combine Dimensions in a Bar Chart

tresB — Thu, 16 Nov 2017 05:46:27 GMT

Please note that if you have to compare without wildcards, using match() is a better choice in terms of performance. And also, be careful of the fact that wildmatch() is case insensitive whereas match() is case sensitive.

Re: Combine Dimensions in a Bar Chart

jmonroe918 — Thu, 16 Nov 2017 05:56:00 GMT

Thanks, I'll keep that in mind

Re: Combine Dimensions in a Bar Chart

arvind_patil — Thu, 16 Nov 2017 06:28:51 GMT

Happy to help you!

Thanks,

Arvind Patil