count of Product id's for different calendar dates:

[stonecold111]

Hi Qliks,

I have two calendar dates order date, delivery date and product id's 

i want to create filter pane which has field "month " that derived from dates.whenever user clicks on particular month

table should filter count of ordered product id's in that month and count of delivered product id's in same month.

How can i do that.  Suggestions please....

[stonecold111]

@sunny_talwar 

[lorenzoconforti · Accepted solution]

If I understood correctly, you want to have a filter where you select a specific month. After you've selected the month, you want to count the number of product id ordered for that month and count the number of product id delivered for that month.

This assumes you have two dates: the date the product was ordered (let's call it orderDate) and the date the product was delivered (deliveryDate)

First of all, your month field you are filtering with needs to be unrelated to the data table (otherwise you will filter your data table when selecting the month)

Then you can count the two values you are looking for by using set analysis. Something like this:

products ordered in the month: count({orderDate = p(month)} productID)

products delivered in the month: count({deliveryDate = p(month)} productID)

If I got the requirements wrong, can you please post your application or an example?

[stonecold111]

Okay,thanks, then how can I create single month field based on two calendar dates. 

[stonecold111]

I think I can create two create two separate months for 2 different dates. Then I can pass selections between two fileds,. 

Expression s going to get effected by both filters.

Works well. Is there any alternative way to do this.just curious to know.

[lorenzoconforti]

I can't see any obvious alternative way

Can you post a picture of your database structure?

[Kashyap_R]

Hi

Try going through the concept of Date Island .

This may help you to get your requirement.

Thanks