topic calculated value in set analysis in QlikView

calculated value in set analysis

Thu, 04 Aug 2011 18:21:02 GMT

Hi,

I have the following expression. Essentially, I am trying to limit the records to one record, based on the average daily volume. The first example shows one department that has an average daily volume of 53. however, this can change from month to month, or department to department .

sum ({$<AVG_DAILY_VOL_DESC ={'53)'}>} RESOURCING)

However, this can change from month to month, or department to department . This doesnt work. However, the calculation does return the correct average daily volume.

sum({$<AVG_DAILY_VOL_DESC ={round(avg({$<MEASURES_DESC={'AVG DAILY VOL'}>}FORECAST_VALUE ))}>} RESOURCING)

So I put the calculation above into a variable called varADV and embedded that in the expression. This doesnt work.

sum ({$<AVG_DAILY_VOL_DESC ={'$(varADV)'}>} RESOURCING)

What am I missing here?

calculated value in set analysis

Thu, 04 Aug 2011 18:46:51 GMT

The syntax for variables in set analysis is a bit different. You will need $(#variable) for variables and $(#=expression) for expression. So in your case use either

sum({$<AVG_DAILY_VOL_DESC ={$(=round(avg({$<MEASURES_DESC={'AVG DAILY VOL'}>}FORECAST_VALUE )))}>} RESOURCING)

sum ({$<AVG_DAILY_VOL_DESC ={$(=$(#varADV))}>} RESOURCING)