Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

11 Replies
Not applicable
Author

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

Not applicable
Author

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