Adjustments using Partial Reload

qlik_venu — Mon, 24 Oct 2011 13:06:17 GMT

hi,

I have a pivot chart with County, City , Year and Sales. ( Year is on the top X- Axis ).

Our users want to change the value for certain Project_id( this is the detail level). They just want to make the sales 0 ( zero) for them.

So i thought we cound provide them with a button, which can do the Partial Reload and then only for the selected Project ids we can multiply the value of the sales by -1.

Sales_F:

Add Only

Load

Country,

City,

Sales

resident Sales_F

where

Projects =$(var_Project_id);

So since this has ADD ONLY, this would work only on the Partial Reload. But the issue is i use a function GetCurrentSelections for the variable ( $(var_Project_id)). I get a error message on Partial Reload tht GetCurrentSelections cannot be used.

var_Project_id : SUBFIELD((GetCurrentSelections(Projects) &':'),':',2)

Can you please suggest me on this. Or is there any other aproach for this problem.

thanks,

Venu

topic Adjustments using Partial Reload in QlikView

Adjustments using Partial Reload