Straight Table excluding filters

mromrod22 — Wed, 25 Nov 2020 16:16:04 GMT

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”

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

(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.

Re: Straight Table excluding filters

mromrod22 — Fri, 25 Aug 2017 06:00:24 GMT

Any idea? Help me, please.

topic Straight Table excluding filters in QlikView

Straight Table excluding filters

Re: Straight Table excluding filters