Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
bvmike2001
New Contributor

Month & day selection from list boxes

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

1 Solution

Accepted Solutions
rajni_batra
Valued Contributor

Re: Month & day selection from list boxes

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!!

6 Replies
Not applicable

Re: Month & day selection from list boxes

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.

bvmike2001
New Contributor

Re: Month & day selection from list boxes

Hello Mhatim,

no, is not such case.

I hve attached 2 printscreens:

1. month selection

1.png

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.

2.png

Not applicable

Re: Month & day selection from list boxes

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

Also can you please post the sample QV file ?

bvmike2001
New Contributor

Re: Month & day selection from list boxes

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

=month(OrderDate)

rajni_batra
Valued Contributor

Re: Month & day selection from list boxes

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!!

bvmike2001
New Contributor

Re: Month & day selection from list boxes

Thanks Rajni,

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

Community Browser