topic compare dates using Set analysis in QlikView

compare dates using Set analysis

Sat, 15 Jun 2013 10:52:00 GMT

Hello All, I am using QV 11 with Pivot table. My pivot table is having 2 dimensions along with other dimensions also. These 2 dimensions are RequiredDate and DeliveredDate. On my expressions side, I have to display as on Required Date how much qty is Delivered. so I have written the expression as sum({< DeliveryDate = {'<=$(=(RequiredDate))'} >} DeliveredQty) But this expression is not giving me correct qty. If I select the Order date then it gives the correct qty. Please guide me on this.

Re: compare dates using Set analysis

spividori — Sat, 15 Jun 2013 12:33:09 GMT

Try the following.

If not, you could upload an example to make it easier to help.

sum({$<RequiredDate={"=DeliveryDate=RequiredDate"}>} DeliveredQty)

Regards.

Re: compare dates using Set analysis

Gysbert_Wassenaar — Sun, 16 Jun 2013 19:38:13 GMT

See attached example for an explanation.

Re: compare dates using Set analysis

Mon, 17 Jun 2013 12:06:14 GMT

Thanks to both... But I got the solution as sum({< DeliveryDate = {'<=$(RequiredDate)'} >} DeliveredQty) and it worked fine.