topic Re: How to fill "cells"? in App Development

How to fill "cells"?

LiquidSword — Mon, 29 Apr 2024 03:50:21 GMT

Don't know how to properly title this question.

PML % is calculated by a couple of measures available in this table. PML is by Report Date, Schedules, and Fabric Number. Each Schedule can have more than one Fabric Number. Each Fabric Number has their own measures that is used to calculate Fabric Number level PML%. The table in this app does not have Fabric Number column, since users usually view PML% on the Schedules level.

Since PML % is viewed on Schedules level, but their can be multiple entries inside each schedule, PML % only shows up once for each Schedule. In other instance, PML % is null. Is there anyway to fill the column, so that, for example, the second PML% is also 1.757% and the fourth one is 1.775% ?

Re: How to fill "cells"?

Vegar — Mon, 29 Apr 2024 04:56:22 GMT

I am assuming you are using some kind of aggr() calculation for PML%.

Adding a NONDISTINCT into that function might help you, like this.

AGGR(TOTAL ....)

See : https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/aggr.htm

Re: How to fill "cells"?

vinieme12 — Mon, 29 Apr 2024 06:01:58 GMT

It's possible to show the PML% values using the TOTAL Keyword as suggested by @Vegar

Sum(TOTAL <Product,Schedule,Fabric> PML )

but if you intend to use this value for further calculations I would suggest you Map the Values in a new column in your data model

Use either Applymap() or Joins to add a new column with PML values for all rows at the required level

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFunctions/ApplyMap.htm

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/combine-tables-join-keep.htm