Static expressions

[mromrod22]

Hi community,

I need modify a expression of bar char, but not look the path.

I have this char, that works with this expression:

count(DISTINCT {<[Tipo Fecha]={$(vTipoFecha)}, Foto={'Publicación anual'}, [Revisión plan anual] = {'Rev0'}>} SOLI_ID_SOLICITUD) +

  count(DISTINCT {<[Tipo Fecha]={$(vTipoFecha)}, Foto={'Publicación anual'}, [Revisión plan anual] = {'*'} - {'Rev0'}, ESSO_ID_ESTADO_BLOQ={1}>} SOLI_ID_SOLICITUD)

And this is my problem:

The results depending of filters, are these:

The numbers in red are that I need change. The results I want are these:

Explain with a example:

Filter -> "Rev0,Rev1,Rev2"

Static values for Rev0 in Ene and Feb, static values for Rev1 in Mar and Abr, and since May to Dic., values of Rev2.

Conclusion: static values for Revs checked and rest of values of the last Rev checked.

Any idea?

Thanks.

[sunny_talwar]

I am glad it helped

Consider marking any helpful responses which you think might help others in the future when they land on this thread

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny