topic Bar Chart y-axis meet x-axis in QlikView

Bar Chart y-axis meet x-axis

mholey234 — Thu, 12 Dec 2019 22:16:55 GMT

Somewhat new to this and could not find any similar articles.

I have a list in column A that have multiple values. I'm trying to create a bar graph where the x-axis is any unique values in column A. Y-axis is to be a total count if that unique value shows up. I've created something in excel, attached, to show what I'm trying to depict as the final graph; however, I'm unable to do it in Qlikview. Any help would be great, thanks in advance!

Re: Bar Chart y-axis meet x-axis

rwunderlich — Fri, 13 Dec 2019 01:19:44 GMT

1. Load the data.

2. Dimension is Interests.

3. Expression is Count(Interests)

-Rob

Re: Bar Chart y-axis meet x-axis

mholey234 — Fri, 13 Dec 2019 02:32:06 GMT

Thanks for the reply Rob. I've tried that and my x-axis have more than one unique value, example would be "Lincoln,KFC,AmericanAir,Dunkin,AmericanAir,Jimmyjohns,Enterprise,Anheiser". What I'm trying to do is have each interest as a unique value in the x-axis and would count 1 if it shows up in column A; example below.

I also tried having multiple expressions like "count({<[Interests]="*KFC*">}){Interests}" but doesn't work.

Re: Bar Chart y-axis meet x-axis

rwunderlich — Fri, 13 Dec 2019 16:21:16 GMT

Sorry I missed that there were multiples on some rows of the input data. Split them up using SubField when you load:

LOAD SubField(Interests, ',') as Interests
FROM [Qlikview Help.xlsx]
(ooxml, embedded labels, table is [Raw Data]);

-Rob