topic Re: Get multiple selected values into chart expression in QlikView

Get multiple selected values into chart expression

Sat, 09 Nov 2013 00:46:25 GMT

Hello!

So I'm new to qlikview and not sure where to start explaining my problem, so please bear with me.

Let's say I want to make a bar chart with one dimension "Model" and the other "Cost"

Each model has a cost related to each quarter it's "on the market"

Each model has a "launch quarter" (LaunchQ) where it's introduced in the market.

So data looks something like this:

Model	LaunchQ	Q1	Q2	Q3
X	Q1	1	2	3
Y	Q2	2	3	4
Z	Q3	3	4	5

Now I want to make a bar chart comparing the "launch cost" for each model (based on listbox selection), ie I only want the LaunchQ cost for each model I select to be shown in the chart, but I can't figure out how to write the expression.

I've been playing around with $ expansion in my expression like: sum([$(=LaunchQ)]) - and it works as long as I only select one "Model" or as long as the different models I select share the same LaunchQ, but as soon as I select Models with different LaunchQ's I get "no data to display". Any ideas?

Kind regards

Andreas

Re: Get multiple selected values into chart expression

Sat, 09 Nov 2013 00:54:47 GMT

CAn you describe The bar chart with a graphical example?

Re: Get multiple selected values into chart expression

andrewpettit — Sat, 09 Nov 2013 02:48:19 GMT

To begin I would load this table using the crosstable function to un-pivot the the Quarters into a single column. It would look something like this:

Crosstable( 'Quarter', 'Cost', 2 )

LOAD

FROM ....

Re: Get multiple selected values into chart expression

Sat, 09 Nov 2013 05:55:22 GMT

Please attach your document

Re: Get multiple selected values into chart expression

bill_mtc — Sat, 09 Nov 2013 06:02:58 GMT

Would be glad helping you, but is it possible to attach even sample app from yours? Thanks.

Re: Get multiple selected values into chart expression

Mon, 11 Nov 2013 02:44:10 GMT

Thanks for all the replies guys! Out travelling at the moment but I'll try to put together some sample data and graphical example of what I would like to achieve shortly.

/Andreas