topic Re: Conditional Set Expresion in QlikView

Conditional Set Expresion

jplozano — Tue, 12 Jun 2018 13:47:11 GMT

Hi guys!

I have a problem with one dashboard. I´m calculating the variation between dates with Set Analysis. This variation can be calculated for 3 distinct clients but i want than the variation value only appears when i select ONLY ONE value.

In other graphics i have more information and i can compare the values for all clientes and i cant force to filter just for a value.

My comparison set analysis is this:

(((Sum({$<Fecha_Valor = {"$(=Date(v_max_date))"}>} [Valor Liquidativo]) - Sum({$<Fecha_Valor = {"$(=Date(v_min_date))"}>} [Valor Liquidativo]))*100)/Sum({$<Fecha_Valor = {"$(=Date(v_max_date))"}>} [Valor Liquidativo]))/100

Valor Liquidativo is my measure.

Fecha_Valor is my time dimension.

Cartera is my new dimension to add.

Could you help me please?

Thank you very much!!

Regards

Re: Conditional Set Expresion

petter — Tue, 12 Jun 2018 14:36:24 GMT

Maybe this will work for you:

=If( Count(DISTINCT Client)=1 ,

)

Re: Conditional Set Expresion

jplozano — Tue, 12 Jun 2018 15:09:53 GMT

Hi!.

I applied this solution but i use GetSelectedCount from the new field .

Thank you very much!!

Re: Conditional Set Expresion

petter — Tue, 12 Jun 2018 18:35:14 GMT

Yes GetSelectedCount() is obviously an alternative way of doing it - should actually be slightly faster too.