Creating a Box that houses one overall total figure that changes based on filtering

[mestevens499]

Hi All,

I currently use QV Personal Edition.

I've been asked to create a summary sheet on QlikView that has one basic overall total (for each applicable fieldname - some of which contains texts) - pretty much like the image below:.

For the life of me it has been a long while since I've done anything like this,  but could some one help me in figuring out how I go about doing this please?

I seem to recall creating text object boxes and then applying expressions to it.  But for some reason this isn't working for me at present.  The SUM expression doesn't appear to work and COUNT is generating duplicating totals regardless of specific fieldname attributions.

Any help / advice would be greatly appreciated.

Thanking you in advance.

Mike.

[brunobertels]

Hi 

you will need first to evaluate which fieldname or dimension is selected 

then depending of it adapt your mesure 

to know which dimension is selected  = GetObjectDimension() Or GetObjectField()

lets say you have 2 dimensions Region and Programmes 

ex : 

if(getObjectdimension()='Region' , MesureyouwantforRegion , 

if(GetObjectdimension() = 'Programmes', MesureyouwantforProgrammes 

))

[Kushal_Chawda]

@mestevens499  Could you please elaborate with example what exactly you want to do?