QV - Expression - Aggr, Set Analysis, Only and Filters

Fri, 20 Nov 2015 15:38:12 GMT

Hi! First of all, sorry for my English.

I can´t do something works.

I'm using a Pivot Grid and expressions with Aggr, Set Analysis and Only functions.

This is the data table.

%PCIID	PVIID	%CONCEPTO	PCIEstado	PVIEstado	Bultos
1		PEDIDOCLIENTE	Confirmado		100
2		PEDIDOCLIENTE	Confirmado		200
3		PEDIDOCLIENTE	Stand By		300
	1	PLANVENTA		Confirmado	100
	2	PLANVENTA		Confirmado	100
	3	PLANVENTA		Confirmado	50
	4	PLANVENTA		Confirmado	50

My original (it works) is to have the Sum of "Bultos" of "PEDIDOCLIENTE", so, i use: Sum(Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'}>} %Bultos),%PCIID))

Now, i added a filter "PVIEstado", but, i want to show the result of the original expression in spite of the value of the filter. So, i tried whith 2 syntaxis but it doesn't work. I tried with:

Sum(Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'},PVIEstado=>} %Bultos),%PCIID))
Sum({<PVIEstado=>}Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'}>} %Bultos),%PCIID))

How can id do?

Thanks

Re: QV - Expression - Aggr, Set Analysis, Only and Filters

Clever_Anjos — Fri, 20 Nov 2015 15:59:11 GMT

Try using both

Sum({<%CONCEPTO={'PEDIDOCLIENTE'},PVIEstado=>}Aggr(only({<%CONCEPTO={'PEDIDOCLIENTE'},PVIEstado=>} %Bultos),%PCIID))

Re: QV - Expression - Aggr, Set Analysis, Only and Filters

Fri, 20 Nov 2015 19:05:45 GMT

Perfect!! Thanks Clever!

topic Re: QV - Expression - Aggr, Set Analysis, Only and Filters in QlikView

QV - Expression - Aggr, Set Analysis, Only and Filters

Re: QV - Expression - Aggr, Set Analysis, Only and Filters

Re: QV - Expression - Aggr, Set Analysis, Only and Filters