Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
CAn you describe The bar chart with a graphical example?
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 ....
Please attach your document
Would be glad helping you, but is it possible to attach even sample app from yours? Thanks.
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