topic Re: Using Multiple Fields in Comparative Analysis in QlikView

Using Multiple Fields in Comparative Analysis

Mon, 18 Nov 2013 07:38:30 GMT

Hi All,

We have a chart where we are analysing the quantity of product produced at plant level hence we are using only one field in Comparative Analysis ie Product Name. We have created the Alternate state for this filed and the chart is showing correct value.

Now, we would like to analyze the same chart based on two fields:

1. Product Name

2. Region Level

I need assistance on how do we do this in Comparative Analysis.

Thanks in Advance

Re: Using Multiple Fields in Comparative Analysis

israrkhan — Mon, 18 Nov 2013 07:48:19 GMT

assign regional level list box to same state, that you have created for Product.

add your [Regional Level] in chart, second dimension(chart already have assigned alternate state)

are create new chart and assign alternate state.

and in the expression do like

sum({State1} Value) for alternate state

sum(value) for your default state, to which you have to compare.

Re: Using Multiple Fields in Comparative Analysis

Mon, 18 Nov 2013 08:43:01 GMT

Thanks it worked !