Visualization issue - I had a solution, but I don't remember ... (stack a combochart)

datanibbler — Mon, 06 Feb 2017 11:00:21 GMT

Hi,

sorry, it's too much of an effort to search all my old Threads for the solution - I had it once, but I did not write my threads with the possibility of searching them later in mind, so I'll rather ask the question again - I have half the solution, that's as much as I have taken down - maybe someone has the other half and can help me:

- I want to create a combochart, but stacked - not possible as a Standard - but why: I want to display a figure each day - the nr. of

lorries that have arrived - in early and late shift. Every day - and both shifts - should be clickable because there are many more details

behind - the vendor, the license_plate, the payload etc.

- The pure barchart can do stacked segments of course, but i cannot click them - only one bar (one day) as a whole.

=> I had the solution once and it involves (that's what I have taken down on the issue) having a second dimension which must

be active at the same time. I think I remember it also involves some visibility_conditions, but that's as far as it goes.

Maybe someone can help me remember? Then I will immediately write it down as part of my standards_documentation which is also a kind of "missing manual", for some issues at least.

There might also be a document in the Community to that end? That would be handy - in case there isn't, I will write one. I'm a fan of always documenting processes and new_found solutions.

Thanks a lot!

Best regards,

DataNibbler

Re: Visualization issue - I had a solution, but I don't remember ... (stack a combochart)

datanibbler — Wed, 08 Feb 2017 12:40:46 GMT

Hmmm ... I have read some of my old posts, but from those I can take only the information that I need two simultaneously active dimensions to get the expressions - there must be two it seems - stacked.

Well, when I have a stacked barchart first, then switch to a combochart and create two dimensions and I have two expressions - both with an IF()-construct in the formula (so that one shows the figures for the early shift and the other shows figures for the late shift only), the properties_dialog still says it's stacked ("design"_tab), but it isn't ...

topic Visualization issue - I had a solution, but I don't remember ... (stack a combochart) in QlikView

Visualization issue - I had a solution, but I don't remember ... (stack a combochart)

Re: Visualization issue - I had a solution, but I don't remember ... (stack a combochart)