topic Re: Ignoring Dimensions in QlikView

Ignoring Dimensions

EGilbert — Fri, 14 Feb 2020 15:33:43 GMT

I have a Stacked Bar/Combo chart and I have a number of Facilities as the bars and each is stacked by the platforms that are made at these facilities. I would like to have a utilization number by facility shown on the axis. I have figured out the formula to calculate the total utilization after some work, but it now puts the utilization on the axis multiple times, based on the number of platforms at each facility. See image below

How can I get the Utilization to be listed only 1 time for each facility? Again the number listed is correct, I just want it listed only once.

Re: Ignoring Dimensions

settu_periasamy — Fri, 14 Feb 2020 16:08:51 GMT

Hi,

Can you provide to sample ?

Re: Ignoring Dimensions

EGilbert — Fri, 14 Feb 2020 17:08:22 GMT

Unfortunately I cannot load any actual data. Below is the formula I used to calculate the Utilization, which is correct

='Utilization =' &num((sum(TOTAL<[PLT VB]> {$<[Platform V]={"*"}-{Open}>}[V demand]))/(Sum(TOTAL <[PLT VB]> DISTINCT [V demand])),'0.%')

Re: Ignoring Dimensions

Brett_Bleess — Wed, 11 Mar 2020 18:10:44 GMT

It is pretty much working as expected given how you have things configured, as it is showing for each segment in the bar. Without a sample QVW file, it is going to be difficult to provide further suggestions on how you might approach things. About the best I can offer is Help link to review the documented functionality, so you can determine for sure if things are as expected or not... If you can provide a sample QVW showing the issue, I suspect you will get further responses.

https://help.qlik.com/en-US/qlikview/April2019/Content/QV_HelpSites/Home.htm

Regards,
Brett