Maintain values according to selection

[cristianj23a]

Hi.

I currently have a table that displays the "HAS INSUMOS" by "VARIEDAD".

Ejm: The VARIEDAD AL has as HA INSUMOS 54.26.

I display that variety and it shows me the HA INSUMOS by "LOT".

I do not want to visualize that, I need to see the HA INSUMOS by VARIEDAD when I display the table that I already did using the TOTAL.

The same for the MATERIAL level.

The next step is that these values have to be maintained when I do any filter, but I can not think of a logic for that.

when I filter a batch it changes its value.

Ejm VARIEDAD AL has as HA INSUMOS 54.26 HA, but when filter a LOTE changes value.

Please help me with that topic.

I attach the qvw.

Greetings.

[sunny_talwar]

Your qvw seems to be protected with section access... but try this

If(WildMatch(Dimensionality(), 0, 1, 2),

Sum({<VARIEDAD., COD_LOTE.>} TOTAL <VARIEDAD.> Aggr(....

...

)

* Avg(1)

[cristianj23a]

Hi Sunny.

I attach the updated qvw.

Greetings.

[cristianj23a]

Use the code but it does not come out as required.

Sum({<VARIEDAD., COD_LOTE.>} TOTAL <VARIEDAD.> Aggr(sum( DISTINCT

{<CONCEPTO={'INSUMOS Y MATERIALES'},BLOQ={'NULL'},DÍA=>}HECTAREA_PRODUCTIVA)

,VARIEDAD., COD_LOTE.)

)* Avg(1)

For VARIEDAD AL should show 54.26 when I filter any LOTE but it is not.

Ejm: If I filter LOTE G06 5.50 appears.

regards.

[sunny_talwar]

Still can't open it because of section access

[Anil_Babu_Samineni]

Try this for a time being?

Sum({<VARIEDAD., COD_LOTE.>} TOTAL <VARIEDAD.> Aggr(sum( DISTINCT

{<CONCEPTO={'INSUMOS Y MATERIALES'},BLOQ={'NULL'},DÍA=, COD_LOTE.>}HECTAREA_PRODUCTIVA)

,VARIEDAD., COD_LOTE.))* Avg({<COD_LOTE., CONCEPTO={'INSUMOS Y MATERIALES'},BLOQ={'NULL'},DÍA=, VARIEDAD.>}1)

[cristianj23a]

Sorry, the Access Section is already disabled.

Good day.

[sunny_talwar · Accepted solution]

Try this

If(WildMatch(Dimensionality(),0,1,2),

Sum({<VARIEDAD., COD_LOTE.>} TOTAL <VARIEDAD.> Aggr(

sum( DISTINCT

{<CONCEPTO = {'INSUMOS Y MATERIALES'}, BLOQ = {'NULL'}, DÍA, VARIEDAD., COD_LOTE.>}HECTAREA_PRODUCTIVA),VARIEDAD.,COD_LOTE.))

,

Sum({<VARIEDAD., COD_LOTE.>} DISTINCT TOTAL <VARIEDAD.> Aggr(

sum( DISTINCT

{<CONCEPTO = {'INSUMOS Y MATERIALES'},BLOQ = {'NULL'},DÍA, VARIEDAD., COD_LOTE.>}HECTAREA_PRODUCTIVA),VARIEDAD.,COD_LOTE.,MATERIAL))

) * Avg({<CONCEPTO = {'INSUMOS Y MATERIALES'},BLOQ = {'NULL'},DÍA>} 1)

[cristianj23a]

thank you.

Use is code and it worked for me.