topic Excel Chart to Qlik Conversion in QlikView

Excel Chart to Qlik Conversion

Wed, 19 Oct 2016 16:28:23 GMT

Been working at this for awhile can anyone help me convert this data?:

Group1 =if(Source= 'X', count(PersonID))

Group2 =if(Source= 'Y', count(PersonID))

into this type of Excel chart (table not needed):

Gysbert_Wassenaar — Wed, 19 Oct 2016 17:11:45 GMT

Create a combi chart with three expressions.

Give the first two expression Bar as Display option

Give the third expression Line and Symbol as Display option

On the Style tab set the Subtype setting to Stacked

On the Axes tab set the Position setting of the third expression to Right (Top) so it gets displayed on the secondary axis.

Wed, 19 Oct 2016 20:17:29 GMT

I was trying this, but was not able to get them to stack.

As a work around you have to turn it to a bar chart first - select stacked - then turn it to a combo chart...... weird

Thanks for your help.

Qlik looks way better than Excel