Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mromrod22
Partner
Partner

Straight Table excluding filters

Hi community,

I have a issue.

I needed count "discharge id´s" excluding filter of date in a bar chart, because should count id´s inside the time interval, and id´s outside the time interval.

The functional say this:


“Filtered min date” <= SOLI_FEC_BEGIN <= “Filtered maxdate


OR

Filtered min date” <= SOLI_FEC_END <= “Filtered max date


OR

(SOLI_FEC_BEGIN <= “Filtered min date”  AND    SOLI_FEC_END >= “Filtered min date”)



I create this expression, and works:



(count (DISTINCT{<Indicador= {'Disparos Intempestivos'}>} [Número Externo de Descargo])

+

count( DISTINCT{ <Indicador= {'Disparos Intempestivos'},[Fecha de Fin Descargo]={">=$(=MakeDate(Año,min(Mes),01))"}>*<Indicador= {'Disparos Intempestivos'},[Fecha de Fin Descargo]={"<=$(=MakeDate(Año,max(Mes),$(vUltimoDiaMaxMes)))"}>}[Número Externo de Descargo])

+

count( DISTINCT{1 <Indicador= {'Disparos Intempestivos'},[Fecha de Inicio Descargo]={"<=$(=MakeDate(Año,min(Mes),01))"}, [Fecha de Fin Descargo]={">=$(=MakeDate(Año,min(Mes),01))"}, AñoDesc=P(Año)>}[Número Externo de Descargo]))

OK.

The issue is next: I need show this id´s, with another fields, in a straight table, but I don´t know how exclude filters and show each id. Count yes, but show... I think that can show with aggr function, but I don´t know...

Help me, please.

1 Reply
mromrod22
Partner
Partner
Author

Any idea? Help me, please.