11 Replies Latest reply: Aug 14, 2013 8:29 AM by Vijit Jindal

# Apply set analysis to by pass selections

Hi,

Currently I have an expression in Straight Table in which I am using IF condition :

> if(campaign=' ' and timescale=' ' , date)

But what is happening is if I make selection in the campaign list box then Staright table report will gone.

So , I have to apply the set analysis so that I can by pass the selections .

What would be the expression for this ?

Thanks

• ###### Re: Apply set analysis to by pass selections

only({1<campaign={' '},timescale={' '}>}date)

• ###### Re: Apply set analysis to by pass selections

Hi Gysbert,

I have to provide the name of the campaign and timescale also so that the dates of that particular campaign will come and side by side have to by pass the selections also so that the report will not gone on any selections.

Thanks.

• ###### Re: Apply set analysis to by pass selections

I have this IF condition in the dimensions and the set is not working in dimension . So how to by pass selections in the dimension .

• ###### Re: Apply set analysis to by pass selections

use the set condition in the expression:

e.g. sum({<campaign=,timescale=>} value)

sum function will ignore any selections on the campaign and timescale dimensions

• ###### Re: Apply set analysis to by pass selections

you can also use this in the dimension:

aggr(if(....),date)

instead of the if you can also use an only I dont know exactly what you need but in the dimension you will have to use the aggr() function

hope this helps

regards,

MT

• ###### Re: Apply set analysis to by pass selections

The following expression will also ignore the selections on campaign and timescale

only({<campaign=,timescale=>}date)

Hope this helps.

Thanks

• ###### Re: Apply set analysis to by pass selections

I have tried to use only({ }) in the dimensions of the straight table chart but it is not working.

• ###### Re: Apply set analysis to by pass selections

you have to wrap the only into an aggr function in the dimenisons.

like:

aggr(only({}date),date)

regards,

MT

• ###### Re: Apply set analysis to by pass selections

I have also tried to use aggr(only({ })) in the dimensions but it is not by passing the selections in the list box.

What I want is :

1. apply this in dimensions

2. In the only want to mention a particular campaign and timescale i.e aggr(only(1{<campaign='Name',timescale='name'>}date),date)

3. Want to bypass the selections in the list box.

Thanks

• ###### Re: Apply set analysis to by pass selections

Did you happen to try this?

Dimension : campaign

Expression: only({<campaign=,timescale=>}date)

• ###### Re: Apply set analysis to by pass selections

yes i have tried the aggr function but you dimension is only capaign?

please try to explain what you are trying to achieve? because you said you wanted to use only() in the dimension but now you are posting that you are using it in the expression