Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Apply set analysis to by pass selections

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


talk is cheap, supply exceeds demand
Not applicable

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.

Not applicable

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 .

Not applicable

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

Not applicable

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

sureshbaabu
Contributor III

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

Not applicable

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.

Not applicable

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

sureshbaabu
Contributor III

Re: Apply set analysis to by pass selections

Did you happen to try this?

Dimension : campaign

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

Community Browser