How to clear all on Set Analysis

[#1]

Dear all,

I have a QV with a comparative specific chart.

I want to do a set analysis clearing all selected filters.

Is any way to do that without put all fields on analysis.,

Thaks a lot for your help.

[swuehl]

Hi,

I think you just need a set identifier {1} then?

like in

=sum( {1} Value)

Regards,

Stefan

[#3]

Dear Stefan,

it works to clear all selections, but if i want to clear all and add manually a new one on set analysis it doesn't work

I want to do something like

{$<1,[YEAR]={'$(Var1)'}>}

Best regards

[kaushiknsolanki]

Hi,

     If you can do like this.

     sum({<Field1 =, Field2= , Field3=, Year = {"$(Var1)"}>}Value)

     Include all the filters. in above expression.

     If you just want full sum with respect to only year then you can try this.

     sum(total <Year>Value)

     Hope this will help you.

Regards,

Kaushik Solanki

[#5]

Dear Kaushik,

I know this way, but it's not the way that I'm looking.

I want to clear all selections without put every field on list.

Imagine that I have near 100 selected fields on a document.

I dont want to put every field on set analysis, I'm looking to clear all and put dessired ones.

On your second example, imagine that i have selected month, on that example month is still selected, but i want to deselect.

=numericcount({$<[YEAR]={"$(YFROM)"}>} TOTAL [SECUENCIA])

Best regards.

[kaushiknsolanki · Accepted solution]

HI,

    Ok then you can try this.

    Sum({1<Year={"$(YFROM)"}>}Values)

    This expression will consider only the filter which you have specified.

Regards,

Kaushik Solanki