topic Need Help for overall analysis in QlikView

Need Help for overall analysis

pgarcia75 — Wed, 27 Jul 2011 08:23:49 GMT

Hi all

I have created a chart with an expression :

count({1<Open_Incident={">$(=MonthStart(AddMonths(now(2),-1)))"},Open_Incident={"<$(=MonthEnd(AddMonths(now(2),-1)))"},GH={GH09},Site={HTD,CCH,BRC}>}[Domaine_Incident])

I want to select a range of dates. I thought the default mode of selection was AND between conditions.

The selection of [Open_Incident] does not work. Only the second term is active.

How can I do?

thank you

Need Help for overall analysis

danielrozental — Wed, 27 Jul 2011 20:04:54 GMT

You need to write it like this

count({1<Open_Incident={">$(=MonthStart(AddMonths(now(2),-1)))<$(=MonthEnd(AddMonths(now(2),-1)))"},GH={GH09},Site={HTD,CCH,BRC}>}[Domaine_Incident])

Need Help for overall analysis

pgarcia75 — Thu, 28 Jul 2011 06:53:44 GMT

It's working

Thanks for all