topic Re: calculation condition in QlikView

calculation condition

Tue, 16 Sep 2014 11:12:49 GMT

I would like a graph to only show results if there are less that 91 days selected on the filter. The issue is that someone might select a month or a number of weeks. There is a field called "date" which would house data for the individual days.

Thank for your help.

Drew

Re: calculation condition

MayilVahanan — Tue, 16 Sep 2014 11:17:24 GMT

Try like this

=Sum({<Year=, Month=, week=, day= , datefield = {">=$(=Date(Max(datefield)-90),'DD/MM/YYYY') < $(=Date(Max(datefield),'DD/MM/YYYY')"}>}Sales)

Change the date format as per your date field.

Re: calculation condition

walterlh — Tue, 16 Sep 2014 11:18:22 GMT

Hola Drew, intentaste con la sección "Limites de Dimensión" en las propiedades del gráfico???

Re: calculation condition

Tue, 16 Sep 2014 12:30:25 GMT

I'm not too sure what the sales field is meant to be? The chart I am using is a combo chart so has a few calculations in it. I thought that it would be possible using a "getselected" statement and could then apply a distinct count on the number of days associated to the selections being made?

Many thanks for your help.

Re: calculation condition

Tue, 16 Sep 2014 12:30:51 GMT

I'm sorry I don't speak Spanish

Re: calculation condition

Anonymous — Tue, 16 Sep 2014 12:37:43 GMT

Hi,

enable conditional checkbox for your expressio, then type:

getselectedcount(date) < 91

Best Regards

Stefan

Re: calculation condition

schlettig — Tue, 16 Sep 2014 12:49:36 GMT

Hi,

if the user is able to select in a different field, you should use:

getpossiblecount(date) as an alternative.

This function gives you for both cases, direct selected (green) in the date field and indirect selected (white) the correct number.

Best regards,

Christian

Re: calculation condition

Tue, 16 Sep 2014 12:54:53 GMT

perfect thank you