topic How to clear all on Set Analysis in QlikView

How to clear all on Set Analysis

Fri, 23 Sep 2011 16:36:23 GMT

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.

How to clear all on Set Analysis

swuehl — Fri, 23 Sep 2011 16:43:25 GMT

Hi,

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

like in

=sum( {1} Value)

Regards,

Stefan

How to clear all on Set Analysis

Mon, 26 Sep 2011 09:48:48 GMT

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

How to clear all on Set Analysis

kaushiknsolanki — Mon, 26 Sep 2011 10:00:54 GMT

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

How to clear all on Set Analysis

Mon, 26 Sep 2011 10:12:37 GMT

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.

How to clear all on Set Analysis

kaushiknsolanki — Mon, 26 Sep 2011 10:17:33 GMT

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