Ignoring some but not all dimensions in a straight table

[#1]

Hello,

I am wondering if there is a way for an expression to ignore some of the demensions of the striaght table that it is in ...but not all. I want to average a score excluding certain demensions.

Any help would be great.

Thanks,

Jeff

[#2 · Accepted solution]

Hello Jeff.

You could use =Sum(TOTAL <dimensions>  Field) where <dimensions> is a comma sepparated list of dimensions to have into account. The expression will ignore any other dimension in the graph.

Hope this helps

Regards,

Luis

[MayilVahanan]

HI

Try like this

Ex: your expression is

= Sum(Sales)

Your dimension is category, product,country, if you want to restrict the product and category dimension, then try like this

=sum(total<category,product> Sales)

by doing this, we can exclude the certain dimension.

Edit:

For additional informatin

Check this

Ignore all selections except some specific fields using Set Analysis

http://community.qlik.com/docs/DOC-1334

Hope it helps

[#4]

You could also look into set analysis. Very powerful!

http://www.qlikblog.at/1384/set-analysis-wizard-qlikview/

Kind Regards,

Dion