topic Re: Bar chart to display multiple fields in QlikView

Bar chart to display multiple fields

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

Dear Qlikview Experts,

I have this set of data wanted to import from excel.

Is it possible for me to create a bar chart with something looks like below?

I want to display all products consumed by customers (1-5) but excluding product B.

I had attached sample of qvw and excel file for your reference. Thank you so much for your time!

Best Regards

Re: Bar chart to display multiple fields

datanibbler — Wed, 16 May 2018 06:18:44 GMT

Hi,

sure you can - make a barchart, give it two dimensions - Customer and Product (customer must be the first dimension in order, you'll see) and you'll get groups of bars. You can either filter out Product B in the script, but you probably want to display it somewhere, no? Then you can build some set_analysis into the formul for your bars to exclude product B.

HTH

Best regards,

DataNibbler

Ah - just had a look at your "Testing.qvw", it won't work that way - you obviously have a crosstable there, with the dimension "Customer" across - you have to load it as such or transpose it so that you have one column "Customer", one column "Product" and one "Value" in your resulting table. Then you can make it into a barchart.

Re: Bar chart to display multiple fields

s10157754 — Wed, 16 May 2018 06:35:50 GMT

Dear Friedrich,

Couldn't figure out on how to achieve the solution based on your explanation. Are you able to guide me step by step?

Best Regards

Re: Bar chart to display multiple fields

s10157754 — Wed, 16 May 2018 07:06:24 GMT

Dear Friedrich,

The alternative solution that I can think of to achieve similar outcome would be using a straight table chart. However, I have problem in removing columns if that particular customer didn't purchase any products. In this case I would like to remove Customer1 column, how can I achieve that using a straight table chart instead?

Best Regards

Re: Bar chart to display multiple fields

tresB — Wed, 16 May 2018 07:09:28 GMT

PFA

Re: Bar chart to display multiple fields

hiteshpatil11 — Wed, 16 May 2018 07:11:14 GMT

Hi Zhang,

You can try this:

1. Load Excel with Cross table to Create Customer as Separate Column:

Table:

CrossTable(Customer,Sales)

LOAD Product,

Customer1,

Customer2,

Customer3,

Customer4,

Customer5

FROM

(ooxml, embedded labels, table is Sheet1);

2. Take Customer and Product Dimensions in Bar Chart in this Order:

3. Expression: Sum(Sales)

4. Check Values on Data Points check box in Expressions

Hope this helps.

Regards,

Hitesh

Re: Bar chart to display multiple fields

s10157754 — Wed, 16 May 2018 08:22:18 GMT

Dear Tresesco B,

Your solution works perfectly for me, just to clarify with you for the calculated dimension. What is the correct syntax if I want to use " = " instead of "<>" ? So that next time I can made changes of the chart if I just want to show a few specific products.

For example change from : =if(Product<>'B',Product)

For example change to : =if(Product='A' , 'C' , 'D', 'E', Product) ?

Re: Bar chart to display multiple fields

tresB — Wed, 16 May 2018 08:52:33 GMT

For example change to : =if(Product='A' , 'C' , 'D', 'E', Product) ?

It would be like:

=if(Match(Product ,'A' , 'C' , 'D', 'E'), Product)