topic help --- Pivot table issue in QlikView

help --- Pivot table issue

Wed, 24 Sep 2014 18:04:22 GMT

I'm having an issue that I will try to describe as best as I can. I have a pivot table that has multiple dimensions (i.e Week, Product, Source, Destination). Right now, I have three expressions - one that shows the shipments, production cost, shipment cost, and total cost.

I also have an expression that looks at a different table to determine the top 3 cheapest sources for each product and how much it would cost to produce and ship from those sources. Whenever I have the pivot table completely collapsed so that it only shows the week... it shows the least cost providers which makes no sense.. because it should only show the least cost providers when the pivot table is expanded to show Week, Product, Source and Destination.

See attachment. It might help better understand what I'm talking about

Re: help --- Pivot table issue

vgutkovsky — Wed, 24 Sep 2014 19:07:32 GMT

Before we start trying to solve this problems with functions like dimensionality(), it sounds like your table only makes sense fully expanded. Just select "Always Fully Expanded" under Presentation in the chart properties.

Vlad

Re: help --- Pivot table issue

Wed, 24 Sep 2014 19:46:53 GMT

Is there any other way around this? I still don't want to see total's for the 'Cheap' columns

Re: help --- Pivot table issue

vgutkovsky — Mon, 29 Sep 2014 15:05:44 GMT

You could try using dimensionality() on your "Cheap" functions. For example: if(dimensionality()=4,only(cheap))

Vlad

Re: help --- Pivot table issue

Tue, 30 Sep 2014 22:25:28 GMT

Where do I use that function? In the script? Expression? Condition?

Re: help --- Pivot table issue

vgutkovsky — Wed, 01 Oct 2014 16:12:43 GMT

Chart expression