topic Re: Maintain values according to selection in QlikView

Maintain values according to selection

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

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.

Re: Maintain values according to selection

sunny_talwar — Thu, 25 Oct 2018 15:36:47 GMT

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)

Re: Maintain values according to selection

cristianj23a — Thu, 25 Oct 2018 19:58:40 GMT

Hi Sunny.

I attach the updated qvw.

Greetings.

Re: Maintain values according to selection

cristianj23a — Thu, 25 Oct 2018 20:57:23 GMT

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.

Re: Maintain values according to selection

sunny_talwar — Fri, 26 Oct 2018 01:07:36 GMT

Still can't open it because of section access

Re: Maintain values according to selection

Anil_Babu_Samineni — Fri, 26 Oct 2018 04:16:16 GMT

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)

Re: Maintain values according to selection

cristianj23a — Fri, 26 Oct 2018 13:06:13 GMT

Sorry, the Access Section is already disabled.

Good day.

Re: Maintain values according to selection

sunny_talwar — Fri, 26 Oct 2018 13:15:31 GMT

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)

Re: Maintain values according to selection

cristianj23a — Fri, 26 Oct 2018 16:41:27 GMT

thank you.

Use is code and it worked for me.