topic maintain values in dynamic selection in QlikView

maintain values in dynamic selection

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

Hi .

I have a table where the HA PROD EJEC is displayed by campaign and year-month.

When I do not select any campaign, the HA PROD EJEC is displayed correctly by campaign in the table.

But when I select a campaign, the HA PROD EJEC is distorted.

Please help me maintain those values when I select any campaign.

attached qvw.

Greetings.

Re: maintain values in dynamic selection

jwjackso — Fri, 11 May 2018 21:28:10 GMT

Add the {1} in the beginning. The first Sum() is based on the current selections.

$(=Sum( {1} Aggr(

sum( DISTINCT

{<CAMPAÑA={"$(='CAMP '&(Max(Num(Right(CAMPAÑA,4)-2))))"},COD_LOTE2-={''},CANT_REAL-={' '},BLOQ={'NULL'},DÍA=>}HECTAREA_PRODUCTIVA),VARIEDAD2,COD_LOTE2))

)

Re: maintain values in dynamic selection

cristianj23a — Mon, 14 May 2018 12:59:20 GMT

Hi Jerry.

It's fine but when I select jul18, it shows me the null value and when I do not select it has value.

Thank you very much.

Greetings.

Re: maintain values in dynamic selection

jwjackso — Mon, 14 May 2018 13:54:41 GMT

CANT_REAL does not appear to be populated for Jul 2018

$(=Sum( {1} Aggr(

sum( DISTINCT

{<CAMPAÑA={"$(='CAMP '&(Max(Num(Right(CAMPAÑA,4)))))"},COD_LOTE2-={''},CANT_REAL-={' '},BLOQ={'NULL'},DÍA=>}HECTAREA_PRODUCTIVA),VARIEDAD2,COD_LOTE2))

)

Re: maintain values in dynamic selection

Anil_Babu_Samineni — Mon, 14 May 2018 14:02:31 GMT

May be this?

$(=Sum( {1} Aggr(

sum( DISTINCT

{<CAMPAÑA={"$(='CAMP '&(Max(Num(Right(CAMPAÑA,4)))))"},COD_LOTE2-={''},CANT_REAL-={"=Len(CANT_REAL) = 0"},BLOQ={'NULL'},DÍA=>}HECTAREA_PRODUCTIVA),VARIEDAD2,COD_LOTE2)))

Re: maintain values in dynamic selection

cristianj23a — Mon, 14 May 2018 14:16:36 GMT

Hi Anil.

the code does not work

Greetings.