Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
))
@mestevens499 Could you please elaborate with example what exactly you want to do?