Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

rogeriogyn
New Contributor III

A 'dimension' applying then selection, and another disconsidering selection

Hi all,

I need a way to show the Total of all expressions in 2 columns, 1 with current selection and another with the total of offices.

It's a pivot table, and the dimension is in columns and the expressions are in rows.

It cannot be another expression like 'sum({<office=>} value1)' because the result needs to be aside, not below.

The qvw is attached. And the image will show what I need:

print1.PNG.png

Rogério

1 Solution

Accepted Solutions
rogeriogyn
New Contributor III

Re: A 'dimension' applying then selection, and another disconsidering selection

It's more simple than I tought.

it's just use the function Dimensionality()

And the expressions goes like:

     IF(Dimensionality()=1, sum(value1), sum({<office=>}value1))

The qvw is attached

1 Reply
rogeriogyn
New Contributor III

Re: A 'dimension' applying then selection, and another disconsidering selection

It's more simple than I tought.

it's just use the function Dimensionality()

And the expressions goes like:

     IF(Dimensionality()=1, sum(value1), sum({<office=>}value1))

The qvw is attached