Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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)
Hi Sunny.
I attach the updated qvw.
Greetings.
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.
Still can't open it because of section access
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)
Sorry, the Access Section is already disabled.
Good day.
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)
thank you.
Use is code and it worked for me.