topic Re: Date question in QlikView

Date question

Tue, 02 Sep 2014 07:51:43 GMT

Hello, i need your help!

my task is to report the open orders for the future and the past,

for example

today 02.09.2014

i only want to select for this example like year '2014' and month '08'

1. I want to report every open order > 30.11.2014

2. I want to reprt every openorder < 01.08.2014

Thanx for your help...

Anonymous — Tue, 02 Sep 2014 07:56:26 GMT

assuming you have a field open orders and you displayed it ina loistbox

define search in the listbox and you canenter

"<01.10.2014' as well as ">30.11.2014"

that what you want?

Tue, 02 Sep 2014 08:04:38 GMT

No, i have to report the € value of the open orders for dimension: customer in a pivot table

and in one column i have to report the € value of the open orders € value <01.10.2014 and

in the second column i have to report the € value of the open orders > 30.11.2014

for the example to select year '2014' and month '08'

Tue, 02 Sep 2014 08:14:52 GMT

Hi,

It should be possible with set analysis, like

Sum({<OrderDate={"=OrderDate<MakeDate(2014,10,1)"}>} OrderValue)

And so on for other dates.

Hope this helps