Apply set analysis to by pass selections

[#1]

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

[Gysbert_Wassenaar]

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

[#3]

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.

[#4]

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 .

[#5]

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

[#6]

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

[sureshbaabu]

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

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

Hope this helps.

Thanks

[#8]

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

[#9]

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

like:

aggr(only({}date),date)

regards,

MT

[sureshbaabu]

Did you happen to try this?

Dimension : campaign

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