topic Re: Month & day selection from list boxes in QlikView

Month & day selection from list boxes

bvmike2001 — Wed, 29 Aug 2012 11:22:34 GMT

Hello,

i have 2 list boxes:

1. with Month extracted from OrderDate field = order creation timestamp

2. with Day extrcted from OrderDate field

If i select one month from 1 list box and then if i want to select a day from the 2 list box, the first selection is cleared.

how can i solve this issue because i want to be able to select month and then day from this two list boxes if i want to find out how many orders i have in a sfecific day of month and for the calculation i made.

Thanks!

Mihai

Re: Month & day selection from list boxes

Wed, 29 Aug 2012 11:48:36 GMT

Dear Mihai,

I think that when you select a Month and then select a date,there is a possibility that the on that corresponding date in that particular month there was no Order placed.Please check and confirm.

Regards

Mhatim.

Re: Month & day selection from list boxes

bvmike2001 — Wed, 29 Aug 2012 11:57:09 GMT

Hello Mhatim,

no, is not such case.

I hve attached 2 printscreens:

1. month selection

2. day selection - you can see that tha previous month selection is gone and i receive results for all the orders created in 10 of june and july not just for june as i wanted to.

Re: Month & day selection from list boxes

Wed, 29 Aug 2012 12:06:07 GMT

Try in the month list box to check "Always one value selected".

Also can you please post the sample QV file ?

Re: Month & day selection from list boxes

bvmike2001 — Wed, 29 Aug 2012 12:13:59 GMT

I can't check that box because it's a calculated field:

=month(OrderDate)

Re: Month & day selection from list boxes

rajni_batra — Thu, 30 Aug 2012 07:21:28 GMT

u must have done this in front end, use the same expressions in Script n extract month and day then use it..

I was also having the same problem, Hope to Help!!

Re: Month & day selection from list boxes

bvmike2001 — Fri, 31 Aug 2012 06:54:57 GMT

Thanks Rajni,

i figured out that this must be the solution and it worked.