Data not showing based on selections

[#1]

Hi,

I have one qvw file. when I am selecting dates the data is not getting based on selections. Coul d anyone let me know why it is not getting as expected.

Thanks.

[salto]

Hello Amelia,

have you linked the dates to the "Transactions" table you want to filter on?

Maybe if you upload the document we could have a look at it and check the reason of this behaviour.

Regards,

[#3]

Hi,

Check the joining between the tables or post your sample application

[bbi_mba_76]

Hi, in your data field there is also the time ?

[#5]

Hi Amelia,

Check your date format once

[MayilVahanan]

HI

There is two possibilities:

1. There is no link between the selections field and the expected field.

2. If you use alternate state, then there is no changes in it.

[#7]

Hi,

I used the link for Transactions and if I checked the Date it is showing values as Integer format.

Please help me

[salto]

Hello Amelia,

I would suggest you to change the date format from integer to DD/MM/YYYY in the load script:

date("Date",'YYYY/MM/DD') as DateID

Use that same field to make the selections.

Would you be so kind to upload the document?

Thanks!

[#9]

Hi,

I have two tables one is Company and other is Transactions.

Company contains Dates upto 2013/09/29

Transactions containd Dates upto 2013/10/01

Could you let me now which table do I need to use to create MasterCalendar

[salto]

Hi,

If you need to filter dates on both tables (Transactions and Company), concatenate them so you have a single table.

Then create the maste calendar, with a Date field that also exists in the table that results of the concatenation of Company and Transactions.

Should you need help creating a Master Calendar please check http://community.qlik.com/thread/30642, or

http://community.qlik.com/thread/91283

Regards.