topic Re: Monthly Percentage in QlikView

Monthly Percentage

cristianj23a — Wed, 25 Nov 2020 16:16:04 GMT

I have a problem with the percentages.

The objective is to calculate the percentages based on the monthly total.

As it is displayed in the image.

the value 1535623.52 is the total for the month of December. This value should be in the Exp2 column.

The same logic must be repeated in each month.

please help me with this topic.

Greetings.

Attached the Qvw

sunny_talwar — Tue, 03 Apr 2018 14:32:57 GMT

Try this for total

If(Dimensionality() = 2,

Sum(TOTAL <NOM_MES> {<FECHA_STOCK={"$(=DATE(NOW()-1,'DD/MM/YYYY'))"},ALMACEN={'*'} - {'290010','390010','930102'}>}STOCK_M2),

Sum(TOTAL{<FECHA_STOCK={"$(=DATE(NOW()-1,'DD/MM/YYYY'))"},ALMACEN={'*'} - {'290010','390010','930102'}>}STOCK_M2))

vishsaggi — Tue, 03 Apr 2018 14:34:38 GMT

try this in your expr2

= sum(TOTAL <NOM_MES> {<FECHA_STOCK={"$(=DATE(NOW()-1,'DD/MM/YYYY'))"},ALMACEN={'*'} - {'290010','390010','930102'}>}STOCK_M2)

vishsaggi — Tue, 03 Apr 2018 14:36:14 GMT

Sunny I thought he said he wants to repeat this for every month not only in Dec so will adding NOM_MES is not enough? Just wondering to know.

vishsaggi — Tue, 03 Apr 2018 14:38:24 GMT

You are right his %ges gets weird if we do not use Dimensionality. Got it.