topic Re: Displaying similar items in a chart in QlikView

Displaying similar items in a chart

Tue, 21 Jul 2015 10:28:58 GMT

Hello,

I am not a highly experienced developer but do dabble a bit. I am trying to produce a column chart that shows amounts for companies and you can look at it for the industry they are in. However when you select a specific Company via a list box, I want it to show all the companies in the same sector.

Ideally I would then like the selected Company to be at the beginning of the chart and all the others to the right in alphabetical order. I have a feeling I am looking at Set Analysis but have been studying this for a couple of hours now and still have no idea how to even start.

Anybody know how to help?

Relevant Fields are:

Code Name

Industry

Amounts

Re: Displaying similar items in a chart

yura_ratu — Tue, 21 Jul 2015 17:04:23 GMT

Hi Kate

I assume you have one row for each company with unique id - Code Name

Try this

=Count( { Industry={"=concat(Industry,',')"} } [Code Name] )

Re: Displaying similar items in a chart

Wed, 22 Jul 2015 08:13:50 GMT

I am sorry but I do not understand the answer. Where does that code go? As a dimension?

I have tried that and it doesn't work, I just get a single bar with an error.

Since posting my original message, I have worked a bit further. I have created a variable that captures the Industry code of a Client when they are selected. What I want to do now is:

Show me a bar chart for all [Code Name] where the Industry is vIndustry, showing the total [number] per [Code Name]

but I do not know how to do this bit

Re: Displaying similar items in a chart

Wed, 22 Jul 2015 09:06:10 GMT

Please give sample data we can help

Re: Displaying similar items in a chart

yura_ratu — Wed, 22 Jul 2015 09:22:25 GMT

Hi Kate,

Sorry, that expression I wrote just in text editor here and it was totally wrong

Please see attached example. Not sure I understood you completely right, but it is something what we can start from !