Sum without affecting selection except few fields.

[amars]

Hi all,

1. I have a dashboard where I need to calculate the DownTime for the Machines as well the Ideal Uptime for them as well.

2. Now on the Tab Activate for Downtime the user wish to select some values from the Downtime Table. I suggested to use the values inside expressions rather than selecting on Tab Activate but for some reasons the user is not agreeing on that.

3.Now as some values from Downtime gets selected the Uptime gets affected and shows uptime only for days where there is some Downtime.

The above behaviour is not expected.

Now even though whatever selection are done, except for fields from Uptime Table, I wish to show the ideal uptime. What Expression I can use to achieve that.

In Uptime table I have Department, Date, Week, Month & Year.

As far as I remember using some Aggr function I should be able to achieve this.

Kindly suggest. Thanks in Advance.

Regards

Amar

[Gysbert_Wassenaar]

You can use set analysis expressions. sum({<Field1=,Field2=>} Sales) will ignore selections in Field1 and Field2 but take selections in other fields into account. Change your expressions to include the set modifiers.

[amars]

Hi Gysbert,

I wish to have it the reverse way. Only selection within specific fields need to be considered otherwise should show all with respect to dimension. Can u suggest something for that.

Thanks

Amar

[Gysbert_Wassenaar · Accepted solution]

You need to put all the fields that should be ignored in the set modifier. If that list is very long you could try the approach described here. If you're using QV11 you could also try using alternate states

[amars]

Thanks a lot Gysbert. That solves my problem..