topic Re: Set analysis in QlikView

Set analysis

Mon, 26 Nov 2012 15:59:52 GMT

Hi!

I use

count({$<[In_Order Date]={'=Year([In_Order Date])=2012'}>} distinct InvoiceNo)

and [In_Order Date] is YYYY-MM-DD hh:mm:ss

I would like to to set expression but with [In_Order Date] between 2011-11-26 and 2012-11-26.

How do I do it?

/Julia

Re: Set analysis

Gysbert_Wassenaar — Mon, 26 Nov 2012 16:24:02 GMT

try:

=count({< [In_Order Date]={'>=2011-11-26<=2012-11-26'} > } distinct InvoiceNo)

if that doesn't work try

=count({< [In_Order Date]={">=$(=date#('2011-11-26 00:00:00','YYYY-MM-DD hh:mm:ss'))<=$(=date#('2012-11-26 00:00:00','YYYY-MM-DD hh:mm:ss'))"} distinct InvoiceNo)

Re: Set analysis

swuehl — Mon, 26 Nov 2012 16:24:30 GMT

Try something like

=count({$<[In_Order Date]={">=$(=num(addmonths(today(),-1)))<=$(=num(today()))"}>} distinct InvoiceNo)