Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Bar Graphic mixing selection of 2 lists

Hey guys,

I'm attaching my original workbook and QVW.

What I need is to show at the 'Bar Graphic' the selection on 'AS IS' and 'OPTIONAL' without bugging my costs.

The way i did there, i'm using the same expression i used on the 'TO BE' List to mix both selection and it works, however the costs get totally wrong because of the variable i think.

If at the Graphic, instead of putting the Expression on 'Dimension's Tab' you select 'Optional', the costs are going to be right but you are only getting the selection from Optional, and i need both selections to show in there (OPTIONAL + 'AS IS' list).

And i also tried to put a TOTAL, at the end, but it's not showing me anything.

Thank you in advance!

2 Replies
Not applicable

Re: Bar Graphic mixing selection of 2 lists

The "AS IS" list box data is coming from different table and there is no link between these two table.

First link these two table and make a link.

If you need AS IS and OPTIONAL values into one Dimension, create another field having both values in Link table and use new field in the Bar chart

Not applicable

Re: Bar Graphic mixing selection of 2 lists

How can i do that?

That 'AS IS' list box contain some selected items from 'OPTIONAL', the costs are the same.

However, if I link the tables using 'OPTIONAL' to link for example, the costs become wrong and the 'TO BE' list, the one with variables in it, doesn't work anymore.

I created a table like this:

AllOptionalTable:

LOAD distinct

     OPTIONAL as AllOptional

FROM

[data config.xlsx]

(ooxml, embedded labels, table is Sheet2);

AllOptionalTable:

LOAD distinct

     OPTIONAL_INSTALLED  as AllOptional

FROM

[data config.xlsx]

(ooxml, embedded labels, table is Instalado);

And then I used this 'AllOptional' at the Graphic and didn't work.