topic Set Analisys Filtering in QlikView

Set Analisys Filtering

marco_puccetti — Tue, 06 Oct 2015 13:05:03 GMT

Hello, i need to know how to do the following thing using set analisys:

I need to get only the list of a field "A" that have related an other field "B" with the value >0, is it possible?

Thanks

Marco

Re: Set Analisys Filtering

nagarjuna_kotha — Tue, 06 Oct 2015 13:12:43 GMT

Yes ,we can do that,

Foe Example you have 10 years data in your dashboard, you want only one Year Sales data only.

Sum({<Field={'A'},Year={'2015'}>}Sales)

Are you looking like this ?

Regards,

Nagarjuna

Re: Set Analisys Filtering

mjm — Tue, 06 Oct 2015 13:26:04 GMT

Hello Marco,

I believe you will need a combination of set analysis and to also use getpossiblevalue to achieve what you need. Your case would be quite complicated, but an example to help can be found here:

Set Analysis - Get List of current selections into specific field

Sum( {<[SalesTargets.STMonth] = {$(=GetFieldSelections(IvMonthNo, ',',12))} >} SalesTargets.Quant)

You will need to of course replace the sum function to use the fields you have and use GetPossibleValue instead, but I believe this will help you.

Please mark this as helpful and correct if this answers your question

Re: Set Analisys Filtering

Tue, 06 Oct 2015 13:30:13 GMT

sum({<fieldA={'A'},value={>0}>}value)

Re: Set Analisys Filtering

marco_puccetti — Tue, 06 Oct 2015 13:36:11 GMT

I have written this expression but it returns me a syntax error:

=Sum({<[FIELD A]={">0"}>}[FIELD A])

What's wrong here?

Thanks

Marco

Re: Set Analisys Filtering

Tue, 06 Oct 2015 13:45:30 GMT

You are ok.

this will give positive values

Re: Set Analisys Filtering

jonathandienst — Tue, 06 Oct 2015 14:22:53 GMT

The expression looks OK, so I am not sure about the error you are seeing - is the field name spelled correctly (including the case)?

This particular calculation can be done more simply:

=Sum(RangeMax(0, [FIELD A]))

Re: Set Analisys Filtering

marco_puccetti — Tue, 06 Oct 2015 14:23:12 GMT

I need to avoid the rows with the latest Column at zero.

Is it possible?

Re: Set Analisys Filtering

Tue, 06 Oct 2015 14:28:07 GMT

The expressions called Premio and Numero di Pezzi do not allow it

Re: Set Analisys Filtering

Tue, 06 Oct 2015 14:31:36 GMT

Use the conditional option , located above the expression.

With sum(Importo Assicu...)>0

Re: Set Analisys Filtering

jonathandienst — Tue, 06 Oct 2015 14:38:09 GMT

The row is suppressed when all expressions return null or zero. Change the other expressions to something like:

=If([Importo Assicurato Unit] <> 0, .... existing expression.... )

Re: Set Analisys Filtering

jonathandienst — Tue, 06 Oct 2015 14:39:20 GMT

Re: Set Analisys Filtering

marco_puccetti — Tue, 06 Oct 2015 14:47:41 GMT

I've solved it using the "{<[Importo Assicurato Fondo]={">0"}>}" condition on all the fields of the column.

Thanks

Marco

Re: Set Analisys Filtering

nagaiank — Tue, 06 Oct 2015 14:48:48 GMT

Did you try this?

If(B > 0,A)

Re: Set Analisys Filtering

marco_puccetti — Tue, 06 Oct 2015 15:32:45 GMT

I've solved it using the "{<[Importo Assicurato Fondo]={">0"}>}" condition on all the fields of the column.

Thanks

Marco

Thanks

Marco