chart: dimension in set analysis

patrou38 — Thu, 29 Nov 2018 14:47:28 GMT

Hello,

in the attached document I've 2 charts.

The first 'With Model', with a dimension 'Model' in the Stacked chart I have 2 portions (Model1 + Model2) .

In the seconde chart 'Without Model', I removed the 'Model' dimension and I 've in the chart only 1 portion. this is correct but my problem is the value of the Bar. I expected to have the sum of the 2 portions but NO !!!

do you have any Idea of Why and how can I do to have this result ? just the sum on the 2 portion (Model1 + Model2)

thank you for your help.

Cordialy,

Patrick

Re: chart: dimension in set analysis

sunny_talwar — Thu, 29 Nov 2018 15:28:17 GMT

Try this

=Sum(Aggr(
Sum(percentage)
 *
 Sum(DISTINCT TC_Inventory)
/
 (Sum(DISTINCT TOTAL TC_Inventory))	/100
, Facility, Work_Week, Model))

topic chart: dimension in set analysis in QlikView

chart: dimension in set analysis

Re: chart: dimension in set analysis